Skip to content

Query: Qry ISP Summary

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

Tables Referenced

  • People Three Plus One ISP Contract
  • Positions
  • People
  • Applications
  • Job Codes
  • People Three Plus One
  • Organisational Codes
  • Pay Points

Columns Selected

  • [People].[Last Name] & \
  • Job
  • [Organisational Codes].[Organisational Unit]
  • [Pay Points].[Pay Point]
  • [KPI Score]/100*[KPI Weighting]

Where Clause

((([Organisational Codes].[Organisational ID])=Forms![Frm Reports ISP Summary Di

SQL

SELECT [People].[Last Name] & \, [Job Codes].Job, [Organisational Codes].[Organisational Unit], [Pay Points].[Pay Point], [KPI Score]/100*[KPI Weighting] FROM [People], [Job Codes], [Positions], [Applications], [People], [Organisational Codes], [Pay Points], [People Three Plus One], [People Three Plus One ISP Contract] WHERE ((([Organisational Codes].[Organisational ID])=Forms![Frm Reports ISP Summary Di