Skip to content

Query: Qry Report Principal Project Allocation Audit

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

Tables Referenced

  • Qry Sum Total Spend by Principal Project
  • vwGarnetRptPrincipalProjectAllocationAudit

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]
  • [Company Name] & IIf([Ring Fencing]=True,\
  • vwGarnetRptPrincipalProjectAllocationAudit.[Contract Start Date]

Where Clause

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

Order By

IIf(IsNull([ProgrammeYrSortOrder]),0,[ProgrammeYrSortOrder]), [Company Name] & IIf([Ring Fencing]=True,\

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], [Company Name] & IIf([Ring Fencing]=True,\, vwGarnetRptPrincipalProjectAllocationAudit.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationAudit], [Qry Sum Total Spend by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationAudit.[Principal Project ID])=Forms![Frm