Skip to content

Query: Qry SubRpt Allocation Replaced by Principal Project

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

Tables Referenced

  • Qry Sum Total Spend by Principal Project
  • Qry
  • vwPurpleSubRptAllocationReplacedbyPrincipalProject

Columns Selected

  • vwPurpleSubRptAllocationReplacedbyPrincipalProject.[BBBEE Pillar Description]
  • vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Company Status ID]
  • IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status])
  • [Principal] & \
  • vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Principal Project ID]
  • vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Company Name]
  • vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Replacement Status]
  • vwPurpleSubRptAllocationReplacedbyPrincipalProject.[BBBEE Pillar]

Where Clause

(((vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Principal Project ID])=[F

SQL

SELECT vwPurpleSubRptAllocationReplacedbyPrincipalProject.[BBBEE Pillar Description], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Company Status ID], IIf(IsNull([Programme Year Status]),[Status],[Programme Year Status]), [Principal] & \, vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Principal Project ID], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Company Name], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Replacement Status], vwPurpleSubRptAllocationReplacedbyPrincipalProject.[BBBEE Pillar] FROM [Qry Sum Total Spend by Principal Project], [vwPurpleSubRptAllocationReplacedbyPrincipalProject] WHERE (((vwPurpleSubRptAllocationReplacedbyPrincipalProject.[Principal Project ID])=[F