Skip to content

Query: Qry Count Unallocated Companies by EP Delivery Location

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • Qry Get Division Dist Model and Rec Info by Company

Columns Selected

  • [Qry Get Division Dist Model and Rec Info by Company].[Delivery Location ID]
  • Count([Qry Get Division Dist Model and Rec Info by Company].[Entrepreneur Compan

Where Clause

((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com

SQL

SELECT [Qry Get Division Dist Model and Rec Info by Company].[Delivery Location ID], Count([Qry Get Division Dist Model and Rec Info by Company].[Entrepreneur Compan FROM [Entrepreneur Company], [Qry Get Division Dist Model and Rec Info by Company] WHERE ((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com