Skip to content

Query: Qry Report Principal Project Allocation Audit

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

Tables Referenced

  • vwGarnetRptPrincipalProjectAllocationAudit
  • Qry Sum Total Spend by Principal Project

Columns Selected

  • vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID]
  • Status
  • IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status])
  • IIf(IsNull([ProgrammeYrSortOrder]),0,[ProgrammeYrSortOrder])
  • vwGarnetRptPrincipalProjectAllocationAudit.[Date Status Changed]
  • vwGarnetRptPrincipalProjectAllocationAudit.[Replacement Status]
  • vwGarnetRptPrincipalProjectAllocationAudit.[Company Name]
  • vwGarnetRptPrincipalProjectAllocationAudit.[Contract Start Date]

Where Clause

(((vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID])=Forms![Frm

Order By

IIf(IsNull([ProgrammeYrSortOrder]),0,[ProgrammeYrSortOrder]), vwGarnetRptPrincipalProjectAllocationAudit.[Company Name]

SQL

SELECT vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationAudit.Status, IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf(IsNull([ProgrammeYrSortOrder]),0,[ProgrammeYrSortOrder]), vwGarnetRptPrincipalProjectAllocationAudit.[Date Status Changed], vwGarnetRptPrincipalProjectAllocationAudit.[Replacement Status], vwGarnetRptPrincipalProjectAllocationAudit.[Company Name], vwGarnetRptPrincipalProjectAllocationAudit.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationAudit], [Qry Sum Total Spend by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID])=Forms![Frm