Skip to content

Query: Qry Awards And Recognition

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

Tables Referenced

  • Positions
  • People
  • Applications
  • Organisational Codes
  • People Awards
  • Companies

Columns Selected

  • Companies.[Company ID]
  • Companies.[Company Name]
  • [Organisational Codes].[Organisational Unit]
  • People.[First Name] & \
  • [People Awards].[Date Captured]
  • Quarter
  • [People Awards].[Quarter Year]
  • [People Awards].[Award Name]
  • Forum
  • [People Awards].[Award Value]
  • Notes

Where Clause

(((Companies.[Company ID])=Forms![Frm Reports Awards and Recognition Dialog]![Co

Order By

[People Awards].[Date Captured]

SQL

SELECT Companies.[Company ID], Companies.[Company Name], [Organisational Codes].[Organisational Unit], People.[First Name] & \, [People Awards].[Date Captured], [People Awards].Quarter, [People Awards].[Quarter Year], [People Awards].[Award Name], [People Awards].Forum, [People Awards].[Award Value], [People Awards].Notes FROM [Companies], [Organisational Codes], [People Awards], [People], [Applications], [Positions] WHERE (((Companies.[Company ID])=Forms![Frm Reports Awards and Recognition Dialog]![Co