Skip to content

Query: Qry SubRpt Purple Panel Results List Date Range

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

Tables Referenced

  • Entrepreneur Company
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • IIf([PP Results]=1,\
  • [Delivery Locations].[Delivery Location]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • Entrepreneurs.[Date Panel Held]

Where Clause

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

Order By

IIf([PP Results]=1,\, [Delivery Locations].[Delivery Location], [First Name] & \

SQL

SELECT IIf([PP Results]=1,\, [Delivery Locations].[Delivery Location], [First Name] & \, [Entrepreneur Company].[Company Name], Entrepreneurs.[Date Panel Held] FROM [Entrepreneurs], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial