Skip to content

Query: SubQry Rpt RAG Criteria

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

Tables Referenced

  • Principal Project Pillars
  • Entrepreneur Company Principal Projects
  • CompanyStatus
  • Principal Projects
  • Qry Count Principal Projects by Company
  • Entrepreneur Company
  • Principal
  • Entrepreneur Company Programme Years

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Status ID]
  • [Entrepreneur Company Principal Projects].[Replacement Status]
  • [Principal Projects].[Principal Project Status ID]
  • [Principal Project Pillars].[Principal Project Pillar ID]
  • [Principal Project Pillars].[Principal Project ID]
  • [Entrepreneur Company Programme Years].[Total Programme Amount]
  • [Entrepreneur Company Principal Projects].[Allocated Amount]
  • [Entrepreneur Company Principal Projects].[Selection Fee]
  • IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection Fee])

Where Clause

((([Principal Projects].[Principal Project Status ID])=2))

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company Principal Projects].[Replacement Status], [Principal Projects].[Principal Project Status ID], [Principal Project Pillars].[Principal Project Pillar ID], [Principal Project Pillars].[Principal Project ID], [Entrepreneur Company Programme Years].[Total Programme Amount], [Entrepreneur Company Principal Projects].[Allocated Amount], [Entrepreneur Company Principal Projects].[Selection Fee], IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection Fee]) FROM [Principal Projects], [Principal Project Pillars], [Entrepreneur Company], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [CompanyStatus], [Qry Count Principal Projects by Company] WHERE ((([Principal Projects].[Principal Project Status ID])=2))