Skip to content

Query: Qry Report Number Companies Ignited by Product

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company Programme Years
  • Products

Columns Selected

  • Product
  • Count([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Yea

Where Clause

((([Entrepreneur Company Programme Years].[Ignition Date])>=[Forms]![Frm Reports

SQL

SELECT Products.Product, Count([Entrepreneur Company Programme Years].[Entrepreneur Company Programme Yea FROM [Entrepreneur Company Programme Years], [Products] WHERE ((([Entrepreneur Company Programme Years].[Ignition Date])>=[Forms]![Frm Reports