Skip to content

Query: Qry SubRpt Purple Panel Results Date Range

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

Tables Referenced

  • Qry
  • Entrepreneurs
  • Qry Count Purple Panel Results Date Range

Columns Selected

  • IIf([PP Results]=1,\
  • Count(Entrepreneurs.[Entrepreneur ID])
  • [Qry Count Purple Panel Results Date Range].[Total Entrepreneurs]

Where Clause

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

SQL

SELECT IIf([PP Results]=1,\, Count(Entrepreneurs.[Entrepreneur ID]), [Qry Count Purple Panel Results Date Range].[Total Entrepreneurs] FROM [Qry Count Purple Panel Results Date Range], [Entrepreneurs] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial