Skip to content

Query: Qry SubRpt Count Records Created by Del Loc

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

Tables Referenced

  • SubQry Count Records Created Dist Model Criteria
  • SubQry
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Distribution Model ID]
  • Active
  • [Delivery Locations].[Delivery Location]
  • [SubQry Count Records Created Dist Model Criteria].[Delivery Location ID]
  • Count([SubQry Count Records Created Dist Model Criteria].[Entrepreneur ID])

SQL

SELECT [Delivery Locations].[Distribution Model ID], [Delivery Locations].Active, [Delivery Locations].[Delivery Location], [SubQry Count Records Created Dist Model Criteria].[Delivery Location ID], Count([SubQry Count Records Created Dist Model Criteria].[Entrepreneur ID]) FROM [SubQry Count Records Created Dist Model Criteria], [Delivery Locations]