Skip to content

Query: SubQry Count EPs With Pipeline Moves Dist Model Criteria

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

Tables Referenced

  • Entrepreneur Status History
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Delivery Location ID]
  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Distribution Model ID]

Where Clause

((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date

SQL

SELECT Entrepreneurs.[Delivery Location ID], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Distribution Model ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=Forms![Frm Reports Date