Skip to content

Query: Qry Report Hired Employee List

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

Tables Referenced

  • Positions
  • People
  • Applications
  • Organisational Codes
  • Job Codes
  • Companies
  • Pay Points

Columns Selected

  • Positions.[Position ID]
  • Positions.[Company ID]
  • Positions.[Position Status ID]
  • Applications.[Application Status ID]
  • Companies.[Company Name]
  • [People].[Last Name] & \
  • People.[Employee Number]
  • Gender
  • Positions.[Employment Status]
  • Race
  • Citizenship
  • IIf([Management]=True,\
  • [Organisational Codes].[Organisational Unit]
  • Job
  • [Pay Points].[Pay Point]
  • Int(DateDiff(\
  • Int(DateDiff(\
  • [People_1].[First Name] & \
  • People_1.[Employee Number]

Where Clause

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

Order By

Companies.[Company Name], [People].[Last Name] & \

SQL

SELECT Positions.[Position ID], Positions.[Company ID], Positions.[Position Status ID], Applications.[Application Status ID], Companies.[Company Name], [People].[Last Name] & \, People.[Employee Number], People.Gender, Positions.[Employment Status], People.Race, People.Citizenship, IIf([Management]=True,\, [Organisational Codes].[Organisational Unit], [Job Codes].Job, [Pay Points].[Pay Point], Int(DateDiff(\, Int(DateDiff(\, [People_1].[First Name] & \, People_1.[Employee Number] FROM [Positions], [Job Codes], [People], [Applications], [Pay Points], [Companies], [Organisational Codes], [People] WHERE (((Positions.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And