Skip to content

Query: Qry Report Selection Team Activity Summary

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

Tables Referenced

  • SubQry Rpt Selection Team Summary Total Passed Panel
  • SubQry Rpt Selection Team Summary Total Graduated Off
  • SubQry Rpt Selection Team Summary Total On Programme
  • SubQry Rpt Selection Team Summary Total Qualified
  • SubQry
  • SubQry Rpt Selection Team Summary Total Passed Assessment
  • SubQry Rpt Selection Team Summary Total Leads Generated
  • SubQry Rpt Selection Team Summary Total Non Graduate
  • Delivery Locations

Columns Selected

  • [Delivery Locations].[Delivery Location]
  • [SubQry Rpt Selection Team Summary Total Leads Generated].[Total Leads Generated
  • IIf(IsNull([Total Qualified]),0,[Total Qualified])
  • IIf(IsNull([Total Passed Assessment]),0,[Total Passed Assessment])
  • IIf(IsNull([Total Passed Panel]),0,[Total Passed Panel])
  • IIf(IsNull([Total Graduated Off]),0,[Total Graduated Off])
  • IIf(IsNull([Total Non Graduate]),0,[Total Non Graduate])
  • IIf(IsNull([Total On Programme]),0,[Total On Programme])

SQL

SELECT [Delivery Locations].[Delivery Location], [SubQry Rpt Selection Team Summary Total Leads Generated].[Total Leads Generated, IIf(IsNull([Total Qualified]),0,[Total Qualified]), IIf(IsNull([Total Passed Assessment]),0,[Total Passed Assessment]), IIf(IsNull([Total Passed Panel]),0,[Total Passed Panel]), IIf(IsNull([Total Graduated Off]),0,[Total Graduated Off]), IIf(IsNull([Total Non Graduate]),0,[Total Non Graduate]), IIf(IsNull([Total On Programme]),0,[Total On Programme]) FROM [SubQry Rpt Selection Team Summary Total Leads Generated], [Delivery Locations], [SubQry Rpt Selection Team Summary Total Qualified], [SubQry Rpt Selection Team Summary Total Passed Assessment], [SubQry Rpt Selection Team Summary Total Passed Panel], [SubQry Rpt Selection Team Summary Total Graduated Off], [SubQry Rpt Selection Team Summary Total Non Graduate], [SubQry Rpt Selection Team Summary Total On Programme]