Skip to content

Query: Qry SubRpt Principal Project Allocation Audit Replaced Companies

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

Tables Referenced

  • Principal Project Pillars
  • Entrepreneur Company Principal Projects
  • CompanyStatus
  • Principal Projects
  • Products
  • CompanyProgrammeYearStatus
  • Entrepreneur Company
  • Principals
  • Qry Sum Total Spend by Principal Project
  • Entrepreneur Company Programme Years
  • Delivery Locations

Columns Selected

  • [Principal Projects].[Principal Project ID]
  • Status
  • IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status])
  • IIf(IsNull([CompanyProgrammeYearStatus].[Sort Order]),0,[CompanyProgrammeYearSta
  • [Entrepreneur Company Programme Years].[Date Status Changed]
  • [Entrepreneur Company Principal Projects].[Replacement Status]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company Programme Years].[Contract Start Date]

Where Clause

((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da

Order By

IIf(IsNull([CompanyProgrammeYearStatus].[Sort Order]),0,[CompanyProgrammeYearSta, [Entrepreneur Company].[Company Name]

SQL

SELECT [Principal Projects].[Principal Project ID], CompanyStatus.Status, IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf(IsNull([CompanyProgrammeYearStatus].[Sort Order]),0,[CompanyProgrammeYearSta, [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company Principal Projects].[Replacement Status], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Products], [Entrepreneur Company], [CompanyStatus], [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Principals], [Qry Sum Total Spend by Principal Project], [CompanyProgrammeYearStatus], [Delivery Locations] WHERE ((([Principal Projects].[Principal Project ID])=[Forms]![Frm Principal Report Da