Skip to content

Query: Qry SubRpt Entrepreneurial Assessment Retake Results List

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

Tables Referenced

  • Entrepreneur Company
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • IIf([EA Retake Results]=1,\
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • [Delivery Locations].[Delivery Location]

Where Clause

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

Order By

IIf([EA Retake Results]=1,\, [First Name] & \

SQL

SELECT IIf([EA Retake Results]=1,\, [First Name] & \, [Entrepreneur Company].[Company Name], [Delivery Locations].[Delivery Location] FROM [Entrepreneurs], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[EA Retake Date])>=[Forms]![Frm Reports Date Dialog]![StartDate