Skip to content

Query: Qry SubRpt Entrepreneurial Assessment Results

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

Tables Referenced

  • Qry Count Entrepreneurial Assessment Results
  • Entrepreneurs

Columns Selected

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

Where Clause

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

SQL

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