Skip to content

Query: Qry SubRpt Executive Daily Summary Tot Apps Recruit by Position

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

Tables Referenced

  • Organisational Codes
  • Job Codes
  • Applications
  • Positions

Columns Selected

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

Where Clause

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

SQL

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