Skip to content

Query: Qry Count Current Raizcorp Possibles by Delivery Location

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

Tables Referenced

  • Qry Get Division Dist Model Del Loc and Rec Info by Company
  • Entrepreneur Company
  • Delivery
  • Delivery Locations

Columns Selected

  • [Entrepreneur Company].[Company Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • Count([Entrepreneur Company].[Entrepreneur Company ID])

Where Clause

((([Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID])=

SQL

SELECT [Entrepreneur Company].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Delivery Locations], [Qry Get Division Dist Model Del Loc and Rec Info by Company], [Entrepreneur Company] WHERE ((([Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID])=