Skip to content

Query: Qry Report Hired and Terminated Employee List

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

Tables Referenced

  • Positions
  • People
  • Applications
  • Date
  • Organisational Codes

Columns Selected

  • Positions.[Position ID]
  • Positions.[Company ID]
  • Positions.[Position Status ID]
  • Applications.[Application Status ID]
  • Gender
  • [Organisational Codes].[Organisational Unit]
  • IIf([Position Status ID]=4,Int(DateDiff(\
  • People.[Group Join Date]

Where Clause

(((Positions.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And

SQL

SELECT Positions.[Position ID], Positions.[Company ID], Positions.[Position Status ID], Applications.[Application Status ID], People.Gender, [Organisational Codes].[Organisational Unit], IIf([Position Status ID]=4,Int(DateDiff(\, People.[Group Join Date] FROM [Positions], [People], [Applications], [Organisational Codes] WHERE (((Positions.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And