Skip to content

Query: Qry Report Regretted CV Not Suitable Info by Position

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

Tables Referenced

  • Position Status
  • Qry Count Total Applications by Position
  • Positions
  • Qry Count Number CV Not Suitable by Position
  • Job Codes
  • Qry Count Number Regretted by Position
  • Pay Points

Columns Selected

  • Positions.[Position Effective Date]
  • Job
  • [Pay Points].[Pay Point]
  • [Position Status].[Position Status]
  • IIf(IsNull([Total Applications]),0,[Total Applications])
  • IIf(IsNull([Number Regretted]),0,[Number Regretted])
  • IIf(IsNull([Number CV Not Suitable]),0,[Number CV Not Suitable])
  • IIf([Tot App]=0,0,[# Regretted]/[Tot App])
  • IIf([Tot App]=0,0,[# CV Not Suitable]/[Tot App])

Where Clause

(((Positions.[Position Effective Date])>=[Forms]![Frm Reports Date Dialog]![Star

SQL

SELECT Positions.[Position Effective Date], [Job Codes].Job, [Pay Points].[Pay Point], [Position Status].[Position Status], IIf(IsNull([Total Applications]),0,[Total Applications]), IIf(IsNull([Number Regretted]),0,[Number Regretted]), IIf(IsNull([Number CV Not Suitable]),0,[Number CV Not Suitable]), IIf([Tot App]=0,0,[# Regretted]/[Tot App]), IIf([Tot App]=0,0,[# CV Not Suitable]/[Tot App]) FROM [Positions], [Job Codes], [Pay Points], [Qry Count Total Applications by Position], [Qry Count Number CV Not Suitable by Position], [Qry Count Number Regretted by Position], [Position Status] WHERE (((Positions.[Position Effective Date])>=[Forms]![Frm Reports Date Dialog]![Star