Skip to content

Query: Qry Report Companies Started Programme Date Range

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

Tables Referenced

  • vwGarnetReportCompaniesStartedProgramme

Columns Selected

  • vwGarnetReportCompaniesStartedProgramme.[Date Status Changed]
  • vwGarnetReportCompaniesStartedProgramme.[Company Programme Year Status ID]
  • vwGarnetReportCompaniesStartedProgramme.[Lump Sum Allocation]
  • vwGarnetReportCompaniesStartedProgramme.[Principal Project]
  • vwGarnetReportCompaniesStartedProgramme.[Company Name]
  • vwGarnetReportCompaniesStartedProgramme.[Ignition Date]
  • vwGarnetReportCompaniesStartedProgramme.[BBBEE Pillar]
  • Product
  • vwGarnetReportCompaniesStartedProgramme.[Programme Year]
  • vwGarnetReportCompaniesStartedProgramme.[Allocated Amount]
  • vwGarnetReportCompaniesStartedProgramme.[Selection Fee]
  • vwGarnetReportCompaniesStartedProgramme.[Total Sponsorship]
  • vwGarnetReportCompaniesStartedProgramme.[Monthly Allocated Amount]
  • vwGarnetReportCompaniesStartedProgramme.[Delivery Location]
  • vwGarnetReportCompaniesStartedProgramme.[Ring Fence]

Where Clause

(((vwGarnetReportCompaniesStartedProgramme.[Date Status Changed])>=[Forms]![Frm

Order By

vwGarnetReportCompaniesStartedProgramme.[Principal Project], vwGarnetReportCompaniesStartedProgramme.[Company Name]

SQL

SELECT vwGarnetReportCompaniesStartedProgramme.[Date Status Changed], vwGarnetReportCompaniesStartedProgramme.[Company Programme Year Status ID], vwGarnetReportCompaniesStartedProgramme.[Lump Sum Allocation], vwGarnetReportCompaniesStartedProgramme.[Principal Project], vwGarnetReportCompaniesStartedProgramme.[Company Name], vwGarnetReportCompaniesStartedProgramme.[Ignition Date], vwGarnetReportCompaniesStartedProgramme.[BBBEE Pillar], vwGarnetReportCompaniesStartedProgramme.Product, vwGarnetReportCompaniesStartedProgramme.[Programme Year], vwGarnetReportCompaniesStartedProgramme.[Allocated Amount], vwGarnetReportCompaniesStartedProgramme.[Selection Fee], vwGarnetReportCompaniesStartedProgramme.[Total Sponsorship], vwGarnetReportCompaniesStartedProgramme.[Monthly Allocated Amount], vwGarnetReportCompaniesStartedProgramme.[Delivery Location], vwGarnetReportCompaniesStartedProgramme.[Ring Fence] FROM [vwGarnetReportCompaniesStartedProgramme] WHERE (((vwGarnetReportCompaniesStartedProgramme.[Date Status Changed])>=[Forms]![Frm