Skip to content

Query: Qry Count Scheduled and Completed Training Modules One Emp

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

Tables Referenced

  • People Training Modules
  • Job
  • Job Code Training Modules

Columns Selected

  • [Job Code Training Modules].[Job ID]
  • [People Training Modules].[People ID]
  • Count([People Training Modules].[Date Scheduled])
  • Count([People Training Modules].[Date Completed])
  • Count([People Training Modules].[Quiz Score])
  • Sum([People Training Modules].[Quiz Score])
  • Count([People Training Modules].[Assessment Score])
  • Sum([People Training Modules].[Assessment Score])

SQL

SELECT [Job Code Training Modules].[Job ID], [People Training Modules].[People ID], Count([People Training Modules].[Date Scheduled]), Count([People Training Modules].[Date Completed]), Count([People Training Modules].[Quiz Score]), Sum([People Training Modules].[Quiz Score]), Count([People Training Modules].[Assessment Score]), Sum([People Training Modules].[Assessment Score]) FROM [Job Code Training Modules], [People Training Modules]