Skip to content

Query: Qry SubRpt Executive Daily Summary Applications Recruit by Stage

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

Tables Referenced

  • Application Status
  • Applications
  • Application Stages
  • Positions

Columns Selected

  • [Application Stages].[Stage Number]
  • [Application Stages].[Application Stage]
  • Count(Applications.[Application ID])

Where Clause

(((Positions.[Position Status ID])=3))

SQL

SELECT [Application Stages].[Stage Number], [Application Stages].[Application Stage], Count(Applications.[Application ID]) FROM [Applications], [Application Status], [Application Stages], [Positions] WHERE (((Positions.[Position Status ID])=3))