Skip to content

Query: Qry Report Companies Allocated Date Range

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

Tables Referenced

  • vwGarnetReportCompaniesAllocated

Columns Selected

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

Where Clause

(((vwGarnetReportCompaniesAllocated.[Date Allocation Created])>=[Forms]![Frm Rep

Order By

vwGarnetReportCompaniesAllocated.[Company Name]

SQL

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