Skip to content

Query: Qry Count All Application Status by Position

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

Tables Referenced

  • Application Status
  • Applications

Columns Selected

  • Applications.[Position ID]
  • [Application Status].[Report Point]
  • [Application Status].[Application Status]
  • [Application Status].[Sort Order]
  • Count(Applications.[Application ID])

Order By

[Application Status].[Sort Order]

SQL

SELECT Applications.[Position ID], [Application Status].[Report Point], [Application Status].[Application Status], [Application Status].[Sort Order], Count(Applications.[Application ID]) FROM [Applications], [Application Status]