Skip to content

Query: Qry Report Companies Left Programme Date Range

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

Tables Referenced

  • vwGarnetReportCompaniesLeftProgramme

Columns Selected

  • vwGarnetReportCompaniesLeftProgramme.[Date Status Changed]
  • vwGarnetReportCompaniesLeftProgramme.[Company Programme Year Status ID]
  • vwGarnetReportCompaniesLeftProgramme.[Lump Sum Allocation]
  • vwGarnetReportCompaniesLeftProgramme.[Principal Project]
  • vwGarnetReportCompaniesLeftProgramme.[Company Name]
  • vwGarnetReportCompaniesLeftProgramme.[Company Status]
  • Product
  • vwGarnetReportCompaniesLeftProgramme.[Programme Year]
  • vwGarnetReportCompaniesLeftProgramme.[Programme Year Status]
  • vwGarnetReportCompaniesLeftProgramme.[Allocated Amount]
  • vwGarnetReportCompaniesLeftProgramme.[Selection Fee]
  • vwGarnetReportCompaniesLeftProgramme.[Total Sponsorship]
  • vwGarnetReportCompaniesLeftProgramme.[Monthly Allocated Amount]
  • vwGarnetReportCompaniesLeftProgramme.[Billed to Date]
  • vwGarnetReportCompaniesLeftProgramme.[To Be Billed]
  • vwGarnetReportCompaniesLeftProgramme.[Delivery Location]
  • vwGarnetReportCompaniesLeftProgramme.[Ring Fence]
  • vwGarnetReportCompaniesLeftProgramme.[Months On Programme]
  • vwGarnetReportCompaniesLeftProgramme.[Replacement Status]

Where Clause

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

Order By

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

SQL

SELECT vwGarnetReportCompaniesLeftProgramme.[Date Status Changed], vwGarnetReportCompaniesLeftProgramme.[Company Programme Year Status ID], vwGarnetReportCompaniesLeftProgramme.[Lump Sum Allocation], vwGarnetReportCompaniesLeftProgramme.[Principal Project], vwGarnetReportCompaniesLeftProgramme.[Company Name], vwGarnetReportCompaniesLeftProgramme.[Company Status], vwGarnetReportCompaniesLeftProgramme.Product, vwGarnetReportCompaniesLeftProgramme.[Programme Year], vwGarnetReportCompaniesLeftProgramme.[Programme Year Status], vwGarnetReportCompaniesLeftProgramme.[Allocated Amount], vwGarnetReportCompaniesLeftProgramme.[Selection Fee], vwGarnetReportCompaniesLeftProgramme.[Total Sponsorship], vwGarnetReportCompaniesLeftProgramme.[Monthly Allocated Amount], vwGarnetReportCompaniesLeftProgramme.[Billed to Date], vwGarnetReportCompaniesLeftProgramme.[To Be Billed], vwGarnetReportCompaniesLeftProgramme.[Delivery Location], vwGarnetReportCompaniesLeftProgramme.[Ring Fence], vwGarnetReportCompaniesLeftProgramme.[Months On Programme], vwGarnetReportCompaniesLeftProgramme.[Replacement Status] FROM [vwGarnetReportCompaniesLeftProgramme] WHERE (((vwGarnetReportCompaniesLeftProgramme.[Date Status Changed])>=[Forms]![Frm Rep