Skip to content

Query: SubQry Get Entrepreneur Steps Owned by Criteria

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • vwPurpleGetEntrepreneurStepsCriteria

Columns Selected

  • OwnedBy
  • vwPurpleGetEntrepreneurStepsCriteria.[Step Number]
  • vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID]
  • vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID]

Where Clause

(((vwPurpleGetEntrepreneurStepsCriteria.OwnedBy)=[Forms]![Frm Step Movement Repo

SQL

SELECT vwPurpleGetEntrepreneurStepsCriteria.OwnedBy, vwPurpleGetEntrepreneurStepsCriteria.[Step Number], vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID], vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID] FROM [vwPurpleGetEntrepreneurStepsCriteria] WHERE (((vwPurpleGetEntrepreneurStepsCriteria.OwnedBy)=[Forms]![Frm Step Movement Repo