Skip to content

Query: Qry People Training Modules NOT in the List

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

Tables Referenced

  • Training Types
  • Training Modules
  • SubQry
  • Job Code Training Modules
  • SubQry People Training Modules NOT in the List
  • Training Courses

Columns Selected

  • [Job Code Training Modules].[Job Code Training Module ID]
  • [Job Code Training Modules].[Job ID]
  • [Training Types].[Training Type]
  • Course
  • Module
  • [Training Modules].[Training Version]
  • Assessment
  • Quiz
  • [Job Code Training Modules].[Sort Order]

Where Clause

((([Job Code Training Modules].[Job ID])=Forms![Frm People Training Information]

SQL

SELECT [Job Code Training Modules].[Job Code Training Module ID], [Job Code Training Modules].[Job ID], [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [Training Modules].[Training Version], [Training Modules].Assessment, [Training Modules].Quiz, [Job Code Training Modules].[Sort Order] FROM [SubQry People Training Modules NOT in the List], [Job Code Training Modules], [Training Types], [Training Courses], [Training Modules] WHERE ((([Job Code Training Modules].[Job ID])=Forms![Frm People Training Information]