Skip to content

Query: SubQry Get Entrepreneur Steps Date Range Criteria

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

Tables Referenced

  • Entrepreneur Status History
  • ProcessStatus

Columns Selected

  • ProcessStatus.[Step Number]
  • [Entrepreneur Status History].[Entrepreneur ID]

Where Clause

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

SQL

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