Skip to content

Query: Qry SubRpt Executive Daily Summary New Applications 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

(((Applications.[Application Date])=[Forms]![Frm Reports Single Date Dialog]![St

SQL

SELECT [Job Codes].Job, [Organisational Codes].[Organisational Unit], Count(Applications.[Application ID]) FROM [Applications], [Positions], [Job Codes], [Organisational Codes] WHERE (((Applications.[Application Date])=[Forms]![Frm Reports Single Date Dialog]![St