Skip to content

Query: Qry SubFrm People Training Module Summary

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

Tables Referenced

  • Qry Count Training Modules One Job Code
  • Qry Count Scheduled and Completed Training Modules One Emp
  • Qry

Columns Selected

  • [Qry Count Training Modules One Job Code].[Total Training Modules per Job]
  • IIf(IsNull([Number Scheduled]),0,[Number Scheduled])
  • IIf(IsNull([Total Training Modules per Job]),0,IIf(IsNull([Number Scheduled]),0,
  • IIf(IsNull([Number Completed]),0,[Number Completed])
  • IIf(IsNull([Number Scheduled]),0,IIf(IsNull([Number Completed]),0,IIf([Number Sc
  • IIf(IsNull([Number Quizes]),0,IIf(IsNull([Total Quiz Score]),0,[Total Quiz Score
  • IIf(IsNull([Number Assessments]),0,IIf(IsNull([Total Assessment Score]),0,[Total

SQL

SELECT [Qry Count Training Modules One Job Code].[Total Training Modules per Job], IIf(IsNull([Number Scheduled]),0,[Number Scheduled]), IIf(IsNull([Total Training Modules per Job]),0,IIf(IsNull([Number Scheduled]),0,, IIf(IsNull([Number Completed]),0,[Number Completed]), IIf(IsNull([Number Scheduled]),0,IIf(IsNull([Number Completed]),0,IIf([Number Sc, IIf(IsNull([Number Quizes]),0,IIf(IsNull([Total Quiz Score]),0,[Total Quiz Score, IIf(IsNull([Number Assessments]),0,IIf(IsNull([Total Assessment Score]),0,[Total FROM [Qry Count Scheduled and Completed Training Modules One Emp], [Qry Count Training Modules One Job Code]