Skip to content

Query: Qry SubRpt Daily Lead Summary Delivery RC Poss All Divs

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

Tables Referenced

  • Qry Get Division Dist Model and Rec Info by Company
  • Products
  • Entrepreneur Company
  • Qry Get Last Programme Year ID by Company
  • Distribution
  • Entrepreneur Company Programme Years
  • Distribution Models
  • Delivery Locations

Columns Selected

  • [Distribution Models].[Distribution Model]
  • [Delivery Locations].[Delivery Location]
  • IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),IIf(IsNull([Entr
  • [Entrepreneur Company].[Company Status ID]
  • Count([Entrepreneur Company].[Entrepreneur Company ID])

Order By

[Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location]

SQL

SELECT [Distribution Models].[Distribution Model], [Delivery Locations].[Delivery Location], IIf(IsNull([Entrepreneur Company Programme Years].[Product ID]),IIf(IsNull([Entr, [Entrepreneur Company].[Company Status ID], Count([Entrepreneur Company].[Entrepreneur Company ID]) FROM [Distribution Models], [Entrepreneur Company], [Qry Get Division Dist Model and Rec Info by Company], [Delivery Locations], [Products], [Qry Get Last Programme Year ID by Company], [Products], [Entrepreneur Company Programme Years]