Skip to content

Query: Qry Report Principal Project Allocation for Finance Nongraduate

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

Tables Referenced

  • 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
  • IIf([Company Programme Year Status ID]=8,IIf(IsNull([Replacement Status]),\
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID]
  • [Principal] & \
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Company Name]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Allocated Amount]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Monthly Allocated Amount]
  • IIf(IsNull([Total Billed]),0,[Total Billed])
  • [Allocated Amount]-[Billed to Date]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Selection Fee]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Selection Fee Type]
  • IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection Fee])
  • vwGarnetRptPrincipalProjectAllocationforFinance.[BBBEE Pillar]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date]
  • vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date]

Where Clause

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

Order By

vwGarnetRptPrincipalProjectAllocationforFinance.[Company Name]

SQL

SELECT vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Status ID], vwGarnetRptPrincipalProjectAllocationforFinance.[Company Programme Year Status I, IIf([Company Programme Year Status ID]=8,IIf(IsNull([Replacement Status]),\, vwGarnetRptPrincipalProjectAllocationforFinance.[Principal Project ID], [Principal] & \, vwGarnetRptPrincipalProjectAllocationforFinance.[Company Name], vwGarnetRptPrincipalProjectAllocationforFinance.[Allocated Amount], vwGarnetRptPrincipalProjectAllocationforFinance.[Monthly Allocated Amount], IIf(IsNull([Total Billed]),0,[Total Billed]), [Allocated Amount]-[Billed to Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Selection Fee], vwGarnetRptPrincipalProjectAllocationforFinance.[Selection Fee Type], IIf(IsNull([Allocated Amount]),0,[Allocated Amount])+IIf(IsNull([Selection Fee]), vwGarnetRptPrincipalProjectAllocationforFinance.[BBBEE Pillar], vwGarnetRptPrincipalProjectAllocationforFinance.[Ignition Date], vwGarnetRptPrincipalProjectAllocationforFinance.[Contract Start Date] FROM [vwGarnetRptPrincipalProjectAllocationforFinance], [Qry Sum Total Billed by Company PP and Project Pillar] WHERE (((vwGarnetRptPrincipalProjectAllocationforFinance.[Lump Sum Allocation])=False)