Skip to content

Query: Qry Report Principal Project Allocation for Finance Blank Year

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

Tables Referenced

  • Qry Count Current Blank Year Companies by Principal Project
  • Qry Count Current Blank Year Entrepreneurs by Principal Project
  • Qry Sum Total Billed by Company PP and Project Pillar
  • vwGarnetRptPrincipalProjectAllocationforFinance

Columns Selected

  • vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Delivery Location]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date]

Where Clause

(((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)

Order By

[Principal] & \

SQL

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Delivery Location], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar], [Qry Count Current Blank Year Companies by Principal Project], [Qry Count Current Blank Year Entrepreneurs by Principal Project] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)