Skip to content

Query: SubQry Rpt Detailed Movement Owned by Criteria

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

Tables Referenced

  • Entrepreneur Status History
  • Entrepreneurs

Columns Selected

  • [Entrepreneur Status History].[Entrepreneur ID]
  • [Entrepreneur Status History].[Date Status Changed]
  • OwnedBy

Where Clause

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

SQL

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