Skip to content

Query: Qry Count Number Regretted by Position

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

Tables Referenced

  • Applications

Columns Selected

  • Applications.[Position ID]
  • Count(Applications.[Application ID])

Where Clause

(((Applications.[Application Status ID])=28))

SQL

SELECT Applications.[Position ID], Count(Applications.[Application ID]) FROM [Applications] WHERE (((Applications.[Application Status ID])=28))