Skip to content

Query: SubQry People Job Training Summary Modules

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

Tables Referenced

  • People Training Modules
  • Job
  • Job Code Training Modules

Columns Selected

  • [Job Code Training Modules].[Job ID]
  • [Job Code Training Modules].[Training Module ID]
  • [People Training Modules].[Date Scheduled]
  • [People Training Modules].[Date Completed]
  • [People Training Modules].[Quiz Score]
  • [People Training Modules].[Assessment Score]

Where Clause

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

SQL

SELECT [Job Code Training Modules].[Job ID], [Job Code Training Modules].[Training Module ID], [People Training Modules].[Date Scheduled], [People Training Modules].[Date Completed], [People Training Modules].[Quiz Score], [People Training Modules].[Assessment Score] FROM [Job Code Training Modules], [People Training Modules] WHERE ((([Job Code Training Modules].[Job ID])=[Forms]![Frm People Training Informatio