Skip to content

Query: SubQry People Training Modules NOT in the List

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

Tables Referenced

  • People Training Modules
  • People

Columns Selected

  • [People Training Modules].[People Training Module ID]
  • [People Training Modules].[People ID]
  • [People Training Modules].[Job Code Training Module ID]

Where Clause

((([People Training Modules].[People ID])=[Forms]![Frm People Training Informati

SQL

SELECT [People Training Modules].[People Training Module ID], [People Training Modules].[People ID], [People Training Modules].[Job Code Training Module ID] FROM [People Training Modules] WHERE ((([People Training Modules].[People ID])=[Forms]![Frm People Training Informati