Skip to content

Query: Qry SubRpt Entrepreneurial Assessment Retake Results

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

Tables Referenced

  • Qry Count Entrepreneurial Assessment Retake Results
  • Entrepreneurs

Columns Selected

  • IIf([EA Retake Results]=1,\
  • Count(Entrepreneurs.[Entrepreneur ID])
  • [Qry Count Entrepreneurial Assessment Retake Results].[Total Entrepreneurs]

Where Clause

(((Entrepreneurs.[EA Retake Date])>=[Forms]![Frm Reports Date Dialog]![StartDate

SQL

SELECT IIf([EA Retake Results]=1,\, Count(Entrepreneurs.[Entrepreneur ID]), [Qry Count Entrepreneurial Assessment Retake Results].[Total Entrepreneurs] FROM [Entrepreneurs], [Qry Count Entrepreneurial Assessment Retake Results] WHERE (((Entrepreneurs.[EA Retake Date])>=[Forms]![Frm Reports Date Dialog]![StartDate