Skip to content

Query: Qry Sum Total Scores by Purple Panelist

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

Tables Referenced

  • Qry
  • Qry Edit Purple Panelists Rubric Metric Scores

Columns Selected

  • [Qry Edit Purple Panelists Rubric Metric Scores].[Purple Panelist ID]
  • Sum([Qry Edit Purple Panelists Rubric Metric Scores].[Possible Score])
  • Sum([Qry Edit Purple Panelists Rubric Metric Scores].[Weighted Score])

SQL

SELECT [Qry Edit Purple Panelists Rubric Metric Scores].[Purple Panelist ID], Sum([Qry Edit Purple Panelists Rubric Metric Scores].[Possible Score]), Sum([Qry Edit Purple Panelists Rubric Metric Scores].[Weighted Score]) FROM [Qry Edit Purple Panelists Rubric Metric Scores]