Skip to content

Query: Qry Report Number Applications by Job Code

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

Tables Referenced

  • Job Codes
  • Applications
  • Positions

Columns Selected

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

Where Clause

(((Applications.[Application Date])>=[Forms]![Frm Reports Date Dialog]![StartDat

SQL

SELECT [Job Codes].[Job ID], [Job Codes].Job, Count(Applications.[Application ID]) FROM [Applications], [Positions], [Job Codes] WHERE (((Applications.[Application Date])>=[Forms]![Frm Reports Date Dialog]![StartDat