Skip to content

Query: SubQry Rubric Metrics NOT in the List

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

Tables Referenced

  • Rubric Metric Templates
  • Rubric

Columns Selected

  • [Rubric Metric Templates].[Rubric Metric Template ID]
  • [Rubric Metric Templates].[Rubric ID]
  • [Rubric Metric Templates].[Metric ID]

Where Clause

((([Rubric Metric Templates].[Rubric ID])=[Forms]![Frm Rubric List]![RubricList]

SQL

SELECT [Rubric Metric Templates].[Rubric Metric Template ID], [Rubric Metric Templates].[Rubric ID], [Rubric Metric Templates].[Metric ID] FROM [Rubric Metric Templates] WHERE ((([Rubric Metric Templates].[Rubric ID])=[Forms]![Frm Rubric List]![RubricList]