Skip to content

Query: Qry Report Panel Passes per Scout

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

Tables Referenced

  • Qry Count Total Panels Held by Scout
  • Qry Count Total Panels Passed by Scout
  • Qry Count Total Assessments Passed by Scout
  • Qry
  • Qry Count Total Assessments Taken by Scout
  • Qry Get Owned By Panels Passed by Scout

Columns Selected

  • OwnedBy
  • [Qry Count Total Assessments Taken by Scout].[Total Assessments Taken]
  • [Qry Count Total Assessments Passed by Scout].[Total Assessments Passed]
  • IIf([Total Assessments Taken]<>0,[Total Assessments Passed]/[Total Assessments T
  • [Qry Count Total Panels Held by Scout].[Total Panels Held]
  • [Qry Count Total Panels Passed by Scout].[Total Panels Passed]
  • IIf([Total Panels Held]<>0,[Total Panels Passed]/[Total Panels Held])

SQL

SELECT [Qry Get Owned By Panels Passed by Scout].OwnedBy, [Qry Count Total Assessments Taken by Scout].[Total Assessments Taken], [Qry Count Total Assessments Passed by Scout].[Total Assessments Passed], IIf([Total Assessments Taken]<>0,[Total Assessments Passed]/[Total Assessments T, [Qry Count Total Panels Held by Scout].[Total Panels Held], [Qry Count Total Panels Passed by Scout].[Total Panels Passed], IIf([Total Panels Held]<>0,[Total Panels Passed]/[Total Panels Held]) FROM [Qry Count Total Panels Held by Scout], [Qry Count Total Panels Passed by Scout], [Qry Count Total Assessments Taken by Scout], [Qry Count Total Assessments Passed by Scout], [Qry Get Owned By Panels Passed by Scout]