Skip to content

Query: SubQry Count EPs With Pipeline Moves Criteria

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

Tables Referenced

  • Entrepreneur Status History
  • ProcessStatus
  • Entrepreneurs

Columns Selected

  • OwnedBy
  • Entrepreneurs.[Entrepreneur ID]

Where Clause

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

SQL

SELECT Entrepreneurs.OwnedBy, Entrepreneurs.[Entrepreneur ID] FROM [Entrepreneurs], [Entrepreneur Status History], [ProcessStatus] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Reports Da