Skip to content

Query: Qry Report Quartz Leads by Phase

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

Tables Referenced

  • Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location
  • Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location
  • Qry Count Unallocated Companies by EP Delivery Location
  • Qry
  • Qry Get Delivery Locations Quartz Lead Phase Report
  • Qry Count Entrepreneurs Pipeline Phase 1 by Delivery Location
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Delivery Location]
  • IIf(IsNull([Number Entrepreneurs Phase 1]),0,[Number Entrepreneurs Phase 1])
  • IIf(IsNull([Number Entrepreneurs Phase 2]),0,[Number Entrepreneurs Phase 2])
  • IIf(IsNull([Number Entrepreneurs Phase 3]),0,[Number Entrepreneurs Phase 3])
  • IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies])

SQL

SELECT [Delivery Locations].[Delivery Location], IIf(IsNull([Number Entrepreneurs Phase 1]),0,[Number Entrepreneurs Phase 1]), IIf(IsNull([Number Entrepreneurs Phase 2]),0,[Number Entrepreneurs Phase 2]), IIf(IsNull([Number Entrepreneurs Phase 3]),0,[Number Entrepreneurs Phase 3]), IIf(IsNull([Unallocated Companies]),0,[Unallocated Companies]) FROM [Qry Get Delivery Locations Quartz Lead Phase Report], [Delivery Locations], [Qry Count Entrepreneurs Pipeline Phase 1 by Delivery Location], [Qry Count Entrepreneurs Pipeline Phase 2 by Delivery Location], [Qry Count Entrepreneurs Pipeline Phase 3 by Delivery Location], [Qry Count Unallocated Companies by EP Delivery Location]