Skip to content

Query: Qry SubRpt Panelists

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

Tables Referenced

  • Purple Panelists
  • Purple
  • DatabaseUsers

Columns Selected

  • [Purple Panelists].[Purple Panel ID]
  • [Purple Panelists].[Business Area]
  • [First Name] & \
  • IIf([Convener]=True,\

SQL

SELECT [Purple Panelists].[Purple Panel ID], [Purple Panelists].[Business Area], [First Name] & \, IIf([Convener]=True,\ FROM [Purple Panelists], [DatabaseUsers]