Skip to content

Query: Qry SubRpt Allocation by Principal Project

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

Tables Referenced

  • vwPurpleSubRptAllocationbyPrincipalProject
  • Qry Sum Total Replaced Billed to Date by Principal Project
  • Qry Count Companies by Principal Project Principal Report
  • Qry Sum Total Replaced Selection Fee by Principal Project
  • Qry Sum Total Spend by Principal Project
  • Qry Count Entrepreneurs by Principal Project Principal Report

Columns Selected

  • vwPurpleSubRptAllocationbyPrincipalProject.[Principal Project ID]
  • vwPurpleSubRptAllocationbyPrincipalProject.[BBBEE Pillar Description]
  • vwPurpleSubRptAllocationbyPrincipalProject.[Company Status ID]
  • IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status])
  • IIf([Ring Fencing]=True,\
  • [Principal] & \
  • vwPurpleSubRptAllocationbyPrincipalProject.[Company Name]
  • vwPurpleSubRptAllocationbyPrincipalProject.[Replacement Status]
  • vwPurpleSubRptAllocationbyPrincipalProject.[BBBEE Pillar]

Where Clause

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

SQL

SELECT vwPurpleSubRptAllocationbyPrincipalProject.[Principal Project ID], vwPurpleSubRptAllocationbyPrincipalProject.[BBBEE Pillar Description], vwPurpleSubRptAllocationbyPrincipalProject.[Company Status ID], IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), IIf([Ring Fencing]=True,\, [Principal] & \, vwPurpleSubRptAllocationbyPrincipalProject.[Company Name], vwPurpleSubRptAllocationbyPrincipalProject.[Replacement Status], vwPurpleSubRptAllocationbyPrincipalProject.[BBBEE Pillar] FROM [vwPurpleSubRptAllocationbyPrincipalProject], [Qry Count Companies by Principal Project Principal Report], [Qry Sum Total Replaced Billed to Date by Principal Project], [Qry Sum Total Replaced Selection Fee by Principal Project], [Qry Count Entrepreneurs by Principal Project Principal Report], [Qry Sum Total Spend by Principal Project] WHERE (((vwPurpleSubRptAllocationbyPrincipalProject.[Principal Project ID])=Forms![Frm