Skip to content

Query: Qry New Starts

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

Tables Referenced

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

Columns Selected

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

Where Clause

(((Companies.[Company ID])=Forms![Frm Reports New Starts Dialog]![Company ID]) A

SQL

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Application Status].[Application Status], [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], [Application Status] WHERE (((Companies.[Company ID])=Forms![Frm Reports New Starts Dialog]![Company ID]) A