Skip to content

Query: SubQry Rpt Purple Panelists Summary Criteria

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

Tables Referenced

  • Entrepreneur
  • Entrepreneurs
  • Entrepreneur Purple Panelists

Columns Selected

  • Entrepreneurs.[Date Panel Held]
  • [Entrepreneur Purple Panelists].[Purple Panelist]
  • Convener
  • Entrepreneurs.[Entrepreneur ID]
  • [Entrepreneur Purple Panelists].[Purple Panelist Score]

Where Clause

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

SQL

SELECT Entrepreneurs.[Date Panel Held], [Entrepreneur Purple Panelists].[Purple Panelist], [Entrepreneur Purple Panelists].Convener, Entrepreneurs.[Entrepreneur ID], [Entrepreneur Purple Panelists].[Purple Panelist Score] FROM [Entrepreneur Purple Panelists], [Entrepreneurs] WHERE (((Entrepreneurs.[Date Panel Held])>=[Forms]![Frm Reports Print Export Date Dial