Skip to content

Query: SubQry Rpt Assessment Panel Passes per Scout

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • OwnedBy
  • Entrepreneurs.[EA Date]
  • Entrepreneurs.[Entrepreneurial Assessment Results]
  • Entrepreneurs.[Date Panel Held]
  • Entrepreneurs.[PP Results]

Where Clause

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

SQL

SELECT Entrepreneurs.OwnedBy, Entrepreneurs.[EA Date], Entrepreneurs.[Entrepreneurial Assessment Results], Entrepreneurs.[Date Panel Held], Entrepreneurs.[PP Results] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[EA Date])>=[Forms]![Frm Reports Date Dialog]![StartDate] And (