Skip to content

Query: SubQry Rpt Part Sponsorship History

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

Tables Referenced

  • Entrepreneur Company Programme Years
  • Entrepreneurs
  • IndustryLookup
  • Delivery Locations
  • Entrepreneur Company
  • Qry Sum Total Allocated Amt by Company
  • Products

Columns Selected

  • [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID]
  • Entrepreneurs.[Process Status ID]
  • [Entrepreneur Company].[Company Status ID]
  • [Delivery Locations].[Delivery Location]
  • [Entrepreneur Company].[Company Name]
  • [First Name] & \
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Email Address]
  • Industry
  • [Entrepreneur Company].[Brief Description of Business]
  • Product
  • [Entrepreneur Company Programme Years].[Total Programme Amount]
  • IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Amt])
  • [Entrepreneur Company Programme Years].[Total Programme Amount]-[Total Allocated
  • [Entrepreneur Company Programme Years].[Programme Year]
  • [Entrepreneur Company Programme Years].[Contract Start Date]

Where Clause

((([Entrepreneur Company Programme Years].[Contract Start Date])>=[Forms]![Frm P

SQL

SELECT [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], Entrepreneurs.[Process Status ID], [Entrepreneur Company].[Company Status ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address], IndustryLookup.Industry, [Entrepreneur Company].[Brief Description of Business], Products.Product, [Entrepreneur Company Programme Years].[Total Programme Amount], IIf(IsNull([Total Allocated Amt]),0,[Total Allocated Amt]), [Entrepreneur Company Programme Years].[Total Programme Amount]-[Total Allocated, [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [IndustryLookup], [Entrepreneurs], [Products], [Entrepreneur Company], [Delivery Locations], [Qry Sum Total Allocated Amt by Company], [Entrepreneur Company Programme Years] WHERE ((([Entrepreneur Company Programme Years].[Contract Start Date])>=[Forms]![Frm P