Skip to content

Query: Qry Report Part Sponsorship History

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

Tables Referenced

  • vwGarnetRptPartSponsorshipHistory

Columns Selected

  • vwGarnetRptPartSponsorshipHistory.[Process Status ID]
  • vwGarnetRptPartSponsorshipHistory.[Company Status ID]
  • vwGarnetRptPartSponsorshipHistory.[Entrepreneur Company Programme Years ID]
  • vwGarnetRptPartSponsorshipHistory.[Delivery Location]
  • vwGarnetRptPartSponsorshipHistory.[Company Name]
  • Entrepreneur
  • Phone
  • vwGarnetRptPartSponsorshipHistory.[Email Address]
  • Industry
  • vwGarnetRptPartSponsorshipHistory.[Brief Description of Business]
  • Product
  • vwGarnetRptPartSponsorshipHistory.[Total Programme Amount]
  • vwGarnetRptPartSponsorshipHistory.[Total Allocated]
  • vwGarnetRptPartSponsorshipHistory.[Amount Needed]
  • vwGarnetRptPartSponsorshipHistory.[Programme Year]
  • vwGarnetRptPartSponsorshipHistory.[Contract Start Date]

Where Clause

(((vwGarnetRptPartSponsorshipHistory.[Contract Start Date])>=[Forms]![Frm Part S

Order By

vwGarnetRptPartSponsorshipHistory.[Delivery Location]

SQL

SELECT vwGarnetRptPartSponsorshipHistory.[Process Status ID], vwGarnetRptPartSponsorshipHistory.[Company Status ID], vwGarnetRptPartSponsorshipHistory.[Entrepreneur Company Programme Years ID], vwGarnetRptPartSponsorshipHistory.[Delivery Location], vwGarnetRptPartSponsorshipHistory.[Company Name], vwGarnetRptPartSponsorshipHistory.Entrepreneur, vwGarnetRptPartSponsorshipHistory.Phone, vwGarnetRptPartSponsorshipHistory.[Email Address], vwGarnetRptPartSponsorshipHistory.Industry, vwGarnetRptPartSponsorshipHistory.[Brief Description of Business], vwGarnetRptPartSponsorshipHistory.Product, vwGarnetRptPartSponsorshipHistory.[Total Programme Amount], vwGarnetRptPartSponsorshipHistory.[Total Allocated], vwGarnetRptPartSponsorshipHistory.[Amount Needed], vwGarnetRptPartSponsorshipHistory.[Programme Year], vwGarnetRptPartSponsorshipHistory.[Contract Start Date] FROM [vwGarnetRptPartSponsorshipHistory] WHERE (((vwGarnetRptPartSponsorshipHistory.[Contract Start Date])>=[Forms]![Frm Part S