Skip to content

Query: Qry Count Current Part Sponsorship by Delivery Location And Type

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

Tables Referenced

  • Delivery
  • Qry Report Part Sponsorship
  • Delivery Locations

Columns Selected

  • [Qry Report Part Sponsorship].[Company Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • IIf(([Company Status ID]<>4) And ([Company Programme Year Status ID]<>6 Or [Comp
  • Count([Qry Report Part Sponsorship].[Entrepreneur Company ID])
  • Sum([Qry Report Part Sponsorship].[Amount Needed])

Order By

[Delivery Locations].[Delivery Location], IIf(([Company Status ID]<>4) And ([Company Programme Year Status ID]<>6 Or [Comp

SQL

SELECT [Qry Report Part Sponsorship].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], IIf(([Company Status ID]<>4) And ([Company Programme Year Status ID]<>6 Or [Comp, Count([Qry Report Part Sponsorship].[Entrepreneur Company ID]), Sum([Qry Report Part Sponsorship].[Amount Needed]) FROM [Delivery Locations], [Qry Report Part Sponsorship]