Skip to content

Query: Qry SubRpt Count Step 1 Status by Del Loc

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

Tables Referenced

  • SubQry
  • SubQry Count Step 1 Status Dist Model Criteria
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Delivery Location]
  • Status
  • Count([SubQry Count Step 1 Status Dist Model Criteria].[Entrepreneur ID])

SQL

SELECT [Delivery Locations].[Delivery Location], [SubQry Count Step 1 Status Dist Model Criteria].Status, Count([SubQry Count Step 1 Status Dist Model Criteria].[Entrepreneur ID]) FROM [SubQry Count Step 1 Status Dist Model Criteria], [Delivery Locations]