Skip to content

Query: Qry Report Purple Panelists Summary

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

Tables Referenced

  • SubQry Rpt Purple Panelists Sum Scores
  • SubQry Rpt Purple Panelists Summary
  • SubQry
  • SubQry Rpt Purple Panelists Convened
  • SubQry Rpt Purple Panelists Attended

Columns Selected

  • [SubQry Rpt Purple Panelists Summary].[Purple Panelist]
  • IIf(IsNull([Number Attended]),0,[Number Attended])
  • IIf(IsNull([Number Convened]),0,[Number Convened])
  • [# Attended]+[# Convened]
  • IIf([Total Panels]=0,0,[Sum of Scores]/[Total Panels])

SQL

SELECT [SubQry Rpt Purple Panelists Summary].[Purple Panelist], IIf(IsNull([Number Attended]),0,[Number Attended]), IIf(IsNull([Number Convened]),0,[Number Convened]), [# Attended]+[# Convened], IIf([Total Panels]=0,0,[Sum of Scores]/[Total Panels]) FROM [SubQry Rpt Purple Panelists Summary], [SubQry Rpt Purple Panelists Attended], [SubQry Rpt Purple Panelists Convened], [SubQry Rpt Purple Panelists Sum Scores]