Skip to content

Query: Qry Count Regret Reasons by Position

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

Tables Referenced

  • Regret Reasons
  • Applications

Columns Selected

  • Applications.[Position ID]
  • Applications.[Regret Reason ID]
  • [Regret Reasons].[Regret Reason]
  • [Regret Reasons].[Sort Order]
  • Count(Applications.[Application ID])

Where Clause

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

SQL

SELECT Applications.[Position ID], Applications.[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], Count(Applications.[Application ID]) FROM [Applications], [Regret Reasons] WHERE (((Applications.[Application Status ID])=28))