Skip to content

Query: Qry Report Selection Team Activity Times by Delivery Location

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

Tables Referenced

  • Entrepreneur Status History
  • ProcessStatus
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • Entrepreneurs.[Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • Status
  • ProcessStatus.[Sort Order]
  • Sum(ProcessStatus.[Time Unit])

Where Clause

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

Order By

[Delivery Locations].[Delivery Location], ProcessStatus.[Sort Order]

SQL

SELECT Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], ProcessStatus.Status, ProcessStatus.[Sort Order], Sum(ProcessStatus.[Time Unit]) FROM [ProcessStatus], [Entrepreneur Status History], [Entrepreneurs], [Delivery Locations] WHERE ((([Entrepreneur Status History].[Date Status Changed])>=[Forms]![Frm Selection