Skip to content

Query: Qry Count Total Panels Passed by Scout

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

Tables Referenced

  • SubQry
  • SubQry Rpt Assessment Panel Passes per Scout

Columns Selected

  • OwnedBy
  • [SubQry Rpt Assessment Panel Passes per Scout].[PP Results]
  • Count([SubQry Rpt Assessment Panel Passes per Scout].[Date Panel Held])

SQL

SELECT [SubQry Rpt Assessment Panel Passes per Scout].OwnedBy, [SubQry Rpt Assessment Panel Passes per Scout].[PP Results], Count([SubQry Rpt Assessment Panel Passes per Scout].[Date Panel Held]) FROM [SubQry Rpt Assessment Panel Passes per Scout]