Skip to content

Query: Qry SubRpt Product Selection Tests Phase 1

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

Tables Referenced

  • Product
  • Product Selection Tests

Columns Selected

  • [Product Selection Tests].[Product ID]
  • [Product Selection Tests].[Phase Number]
  • [Product Selection Tests].[Selection Test]
  • IIf([Gate]=1,\
  • [Product Selection Tests].[Percentage to Pass]
  • IIf([Average]=True,\

Where Clause

((([Product Selection Tests].[Phase Number])=1))

SQL

SELECT [Product Selection Tests].[Product ID], [Product Selection Tests].[Phase Number], [Product Selection Tests].[Selection Test], IIf([Gate]=1,\, [Product Selection Tests].[Percentage to Pass], IIf([Average]=True,\ FROM [Product Selection Tests] WHERE ((([Product Selection Tests].[Phase Number])=1))