Skip to content

Query: SubQry Principal Retention Process Steps NOT in Process

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

Tables Referenced

  • Product Principal Retention Process
  • Product

Columns Selected

  • [Product Principal Retention Process].[Product Principal Retention Process ID]
  • [Product Principal Retention Process].[Product ID]
  • [Product Principal Retention Process].[Principal Retention Process Step ID]
  • [Product Principal Retention Process].[Month Number]
  • [Product Principal Retention Process].[Step Number]
  • [Product Principal Retention Process].[nPrincipal Retention Process Step ID]

Where Clause

((([Product Principal Retention Process].[Product ID])=[Forms]![Frm Add and Edit

SQL

SELECT [Product Principal Retention Process].[Product Principal Retention Process ID], [Product Principal Retention Process].[Product ID], [Product Principal Retention Process].[Principal Retention Process Step ID], [Product Principal Retention Process].[Month Number], [Product Principal Retention Process].[Step Number], [Product Principal Retention Process].[nPrincipal Retention Process Step ID] FROM [Product Principal Retention Process] WHERE ((([Product Principal Retention Process].[Product ID])=[Forms]![Frm Add and Edit