Skip to content

Query: Qry Report Application Status Ratio

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

Tables Referenced

  • Position Status
  • Qry Count Total Applications by Position
  • Positions
  • Job Codes
  • Qry Sum Total Application Status Times by Position
  • Qry Count All Application Status by Position
  • Pay Points

Columns Selected

  • Positions.[Position ID]
  • Job
  • [Pay Points].[Pay Point]
  • [Qry Count Total Applications by Position].[Total Applications]
  • [Qry Count All Application Status by Position].[Application Status]
  • [Qry Count All Application Status by Position].[Sort Order]
  • [Qry Count All Application Status by Position].[Number of Applications]
  • Round([Total Minutes Spent]/60,2)

Where Clause

(((Positions.[Position ID])=[Forms]![Frm Filled Position Report Dialog]![Positio

Order By

[Qry Count All Application Status by Position].[Sort Order]

SQL

SELECT Positions.[Position ID], [Job Codes].Job, [Pay Points].[Pay Point], [Qry Count Total Applications by Position].[Total Applications], [Qry Count All Application Status by Position].[Application Status], [Qry Count All Application Status by Position].[Sort Order], [Qry Count All Application Status by Position].[Number of Applications], Round([Total Minutes Spent]/60,2) FROM [Positions], [Position Status], [Qry Count Total Applications by Position], [Job Codes], [Pay Points], [Qry Count All Application Status by Position], [Qry Sum Total Application Status Times by Position] WHERE (((Positions.[Position ID])=[Forms]![Frm Filled Position Report Dialog]![Positio