Skip to content

Query: Qry Count Total Panels Held 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
  • Count([SubQry Rpt Assessment Panel Passes per Scout].[Date Panel Held])

SQL

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