Skip to content

Query: Qry Count Purple Panel Results Date Range

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

(((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial

SQL

SELECT Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial