Skip to content

Query: Qry SubRpt Executive Daily Summary Status Changes Recruit by Pos

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

Tables Referenced

  • Application Status History
  • Positions
  • Applications
  • Job Codes
  • Organisational Codes

Columns Selected

  • Job
  • [Organisational Codes].[Organisational Unit]
  • Count([Application Status History].[Application Status History ID])

Where Clause

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

SQL

SELECT [Job Codes].Job, [Organisational Codes].[Organisational Unit], Count([Application Status History].[Application Status History ID]) FROM [Applications], [Positions], [Job Codes], [Organisational Codes], [Application Status History] WHERE (((Positions.[Position Status ID])=3))