Skip to content

Query: Qry Report Opal Principal Projects by Industry

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

Tables Referenced

  • Qry Sum Total Sponsorship by Principal Project
  • Qry Sum Total Spend by Principal Project
  • Qry Count Current Active Allocated Companies On Pgm by Prin Proj
  • Qry Count Exited Companies by Principal Project
  • Qry Sum Total Replaced Billed to Date by Principal Project
  • Qry Count Exited Need Replacement by Principal Project
  • Qry Count Unallocated Companies by Principal Project Recommended
  • SubQry
  • SubQry Rpt Opal Principal Projects by Industry

Columns Selected

  • Industry
  • [SubQry Rpt Opal Principal Projects by Industry].[Principal Project]
  • IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje
  • IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total
  • [Rands Required]-[Total Sponsorship]
  • [SubQry Rpt Opal Principal Projects by Industry].[Companies Required]
  • [Qry Count Current Active Allocated Companies On Pgm by Prin Proj].[Number Activ
  • [Qry Count Exited Companies by Principal Project].[Number Exited Companies]
  • [Qry Count Exited Need Replacement by Principal Project].[Number of Exited Need
  • [Qry Count Unallocated Companies by Principal Project Recommended].[Unallocated

Order By

[SubQry Rpt Opal Principal Projects by Industry].Industry, [SubQry Rpt Opal Principal Projects by Industry].[Principal Project]

SQL

SELECT [SubQry Rpt Opal Principal Projects by Industry].Industry, [SubQry Rpt Opal Principal Projects by Industry].[Principal Project], IIf(IsNull([Total Spend by Principal Project]),0,[Total Spend by Principal Proje, IIf(IsNull([Total Sponsorship Amt]),0,[Total Sponsorship Amt])+IIf(IsNull([Total, [Rands Required]-[Total Sponsorship], [SubQry Rpt Opal Principal Projects by Industry].[Companies Required], [Qry Count Current Active Allocated Companies On Pgm by Prin Proj].[Number Activ, [Qry Count Exited Companies by Principal Project].[Number Exited Companies], [Qry Count Exited Need Replacement by Principal Project].[Number of Exited Need , [Qry Count Unallocated Companies by Principal Project Recommended].[Unallocated  FROM [SubQry Rpt Opal Principal Projects by Industry], [Qry Sum Total Spend by Principal Project], [Qry Sum Total Sponsorship by Principal Project], [Qry Sum Total Replaced Billed to Date by Principal Project], [Qry Count Current Active Allocated Companies On Pgm by Prin Proj], [Qry Count Exited Companies by Principal Project], [Qry Count Exited Need Replacement by Principal Project], [Qry Count Unallocated Companies by Principal Project Recommended]