Skip to content

Query: Qry Time To Fill

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

Tables Referenced

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

Columns Selected

  • Companies.[Company Name]
  • [Organisational Codes].[Organisational Unit]
  • [People].[First Name] & \
  • Job
  • [Position Status].[Position Status]
  • Positions.[Position Effective Date]
  • Positions.[Start Date]
  • Positions.[Termination Date]
  • DateDiff(\
  • [Pay Points].[Pay Point]
  • [People_1].[First Name] & \
  • [Pay Points].[Pay Point]
  • Positions.[Position Status ID]
  • Applications.[Application Status ID]

Where Clause

(((Positions.[Start Date])>=Forms![Frm Reports Time To Fill Dialog]![Start Date]

SQL

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Job Codes].Job, [Position Status].[Position Status], Positions.[Position Effective Date], Positions.[Start Date], Positions.[Termination Date], DateDiff(\, [Pay Points].[Pay Point], [People_1].[First Name] & \, [Pay Points].[Pay Point], Positions.[Position Status ID], Applications.[Application Status ID] FROM [People], [Positions], [Position Status], [People], [Applications], [Pay Points], [Companies], [Organisational Codes], [Job Codes] WHERE (((Positions.[Start Date])>=Forms![Frm Reports Time To Fill Dialog]![Start Date]