Skip to content

Query: Qry Purple Panelist List

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

Tables Referenced

  • Purple Panelists
  • Purple

Columns Selected

  • [Purple Panelists].[Purple Panelist ID]
  • [Purple Panelists].[Purple Panel ID]
  • [Purple Panelists].[Purple Panelist]
  • [Purple Panelists].[Business Area]
  • [Purple Panelists].[Purple Panelist Total Score]
  • IIf([Convener]=True,\
  • IIf([Submitted]=True,\

SQL

SELECT [Purple Panelists].[Purple Panelist ID], [Purple Panelists].[Purple Panel ID], [Purple Panelists].[Purple Panelist], [Purple Panelists].[Business Area], [Purple Panelists].[Purple Panelist Total Score], IIf([Convener]=True,\, IIf([Submitted]=True,\ FROM [Purple Panelists]