Skip to content

Query: Qry SubRpt Entrepreneurial Assessment Results List

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

Tables Referenced

  • Entrepreneur Company
  • Entrepreneurs
  • Delivery Locations

Columns Selected

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

Where Clause

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

Order By

IIf([Entrepreneurial Assessment Results]=1,\, [First Name] & \

SQL

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