Skip to content

Query: Qry Exits

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

Tables Referenced

  • Position Status
  • Positions
  • People
  • Applications
  • Organisational Codes
  • Companies
  • Pay Points

Columns Selected

  • Companies.[Company Name]
  • [Organisational Codes].[Organisational Unit]
  • [People].[First Name] & \
  • [Position Status].[Position Status]
  • Positions.[Start Date]
  • [Pay Points].[Pay Point]
  • [People_1].[First Name] & \

Where Clause

(((Positions.[Start Date])>=[Forms]![Frm Reports Exits Dialog]![Start Date] And

SQL

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Position Status].[Position Status], Positions.[Start Date], [Pay Points].[Pay Point], [People_1].[First Name] & \ FROM [People], [Positions], [Position Status], [People], [Applications], [Pay Points], [Companies], [Organisational Codes] WHERE (((Positions.[Start Date])>=[Forms]![Frm Reports Exits Dialog]![Start Date] And