Skip to content

Query: Qry SubRpt Lead Summary Referred to Prosperator Date Range

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

Tables Referenced

  • Entrepreneur Status History
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • Count(Entrepreneurs.[Entrepreneur ID])
  • [Entrepreneur Status History].[Process Status ID]
  • [Delivery Locations].[Delivery Location]

Where Clause

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

SQL

SELECT Count(Entrepreneurs.[Entrepreneur ID]), [Entrepreneur Status History].[Process Status ID], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Entrepreneur Status History], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Reports Da