Skip to content

Query: SubQry Rpt Delivery vs Exited Entrepreneurs

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company Status History

Columns Selected

  • [Entrepreneur Company Status History].[Entrepreneur Company ID]
  • [Entrepreneur Company Status History].[Company Status ID]

Where Clause

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

SQL

SELECT [Entrepreneur Company Status History].[Entrepreneur Company ID], [Entrepreneur Company Status History].[Company Status ID] FROM [Entrepreneur Company Status History] WHERE ((([Entrepreneur Company Status History].[Date Status Changed])>=[Forms]![Frm De