Skip to content

Query: Qry Edit Purple Panelists Rubric Metric Scores

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

Tables Referenced

  • Purple Panelists Scores
  • Rubric Metric Templates
  • Purple
  • Metrics

Columns Selected

  • Unused
  • [Purple Panelists Scores].[Purple Panelist ID]
  • [Purple Panelists Scores].[Purple Panelist Score ID]
  • 5*[Metric Weight]
  • Metrics.[Metric ID]
  • Metric
  • Metrics.[Metric Description]
  • [Purple Panelists Scores].[Purple Panelist Score]
  • IIf(IsNull([Purple Panelist Score]) Or [Purple Panelist Score]=0,\
  • [Purple Panelist Score]*[Metric Weight]
  • Metrics.[Sort Order]

Where Clause

((([Purple Panelists Scores].Unused)=False))

Order By

Metrics.[Sort Order]

SQL

SELECT [Purple Panelists Scores].Unused, [Purple Panelists Scores].[Purple Panelist ID], [Purple Panelists Scores].[Purple Panelist Score ID], 5*[Metric Weight], Metrics.[Metric ID], Metrics.Metric, Metrics.[Metric Description], [Purple Panelists Scores].[Purple Panelist Score], IIf(IsNull([Purple Panelist Score]) Or [Purple Panelist Score]=0,\, [Purple Panelist Score]*[Metric Weight], Metrics.[Sort Order] FROM [Purple Panelists Scores], [Rubric Metric Templates], [Metrics] WHERE ((([Purple Panelists Scores].Unused)=False))