Skip to content

Query: Qry SubRpt Sponsorship Elements by Principal Project

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

Tables Referenced

  • Qry Sum Sponsor Elements Payments by Company
  • vwPurpleSubRptSponsorshipbyPrincipalProject
  • Qry Sum Total Sponsor Elements by Principal Project
  • Qry Sum Total Sponsor Elements Spend by Principal Project

Columns Selected

  • vwPurpleSubRptSponsorshipbyPrincipalProject.[Principal Project ID]
  • vwPurpleSubRptSponsorshipbyPrincipalProject.[Company Name]
  • vwPurpleSubRptSponsorshipbyPrincipalProject.[BBBEE Pillar]
  • vwPurpleSubRptSponsorshipbyPrincipalProject.[Element Type]
  • vwPurpleSubRptSponsorshipbyPrincipalProject.[Extra Sponsorship Amount]
  • IIf(IsNull([Total Company Payments]),0,[Total Company Payments])
  • [Qry Sum Total Sponsor Elements by Principal Project].[Total Sponsor Elements]
  • IIf(IsNull([Total Sponsorship Spend]),0,[Total Sponsorship Spend])
  • [Total Sponsor Elements]-[Total Spend]

Where Clause

(((vwPurpleSubRptSponsorshipbyPrincipalProject.[Principal Project ID])=[Forms]![

SQL

SELECT vwPurpleSubRptSponsorshipbyPrincipalProject.[Principal Project ID], vwPurpleSubRptSponsorshipbyPrincipalProject.[Company Name], vwPurpleSubRptSponsorshipbyPrincipalProject.[BBBEE Pillar], vwPurpleSubRptSponsorshipbyPrincipalProject.[Element Type], vwPurpleSubRptSponsorshipbyPrincipalProject.[Extra Sponsorship Amount], IIf(IsNull([Total Company Payments]),0,[Total Company Payments]), [Qry Sum Total Sponsor Elements by Principal Project].[Total Sponsor Elements], IIf(IsNull([Total Sponsorship Spend]),0,[Total Sponsorship Spend]), [Total Sponsor Elements]-[Total Spend] FROM [vwPurpleSubRptSponsorshipbyPrincipalProject], [Qry Sum Total Sponsor Elements by Principal Project], [Qry Sum Sponsor Elements Payments by Company], [Qry Sum Total Sponsor Elements Spend by Principal Project] WHERE (((vwPurpleSubRptSponsorshipbyPrincipalProject.[Principal Project ID])=[Forms]![