Skip to content

Query: SubQry Get Entrepreneur Steps Lead Type Criteria

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

Tables Referenced

  • vwPurpleGetEntrepreneurStepsCriteria

Columns Selected

  • vwPurpleGetEntrepreneurStepsCriteria.[Lead Type ID]
  • vwPurpleGetEntrepreneurStepsCriteria.[Step Number]
  • vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID]
  • vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID]

Where Clause

(((vwPurpleGetEntrepreneurStepsCriteria.[Lead Type ID])=[Forms]![Frm Step Moveme

SQL

SELECT vwPurpleGetEntrepreneurStepsCriteria.[Lead Type ID], vwPurpleGetEntrepreneurStepsCriteria.[Step Number], vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID], vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID] FROM [vwPurpleGetEntrepreneurStepsCriteria] WHERE (((vwPurpleGetEntrepreneurStepsCriteria.[Lead Type ID])=[Forms]![Frm Step Moveme