Skip to content

Query: Qry Warnings

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

Tables Referenced

  • Positions
  • People
  • Applications
  • People Disciplinary Warning Letters
  • Companies

Columns Selected

  • Companies.[Company Name]
  • People.[First Name] & \
  • [People Disciplinary Warning Letters].[Date Issued]
  • [People Disciplinary Warning Letters].[Issued By]
  • Reason
  • [People Disciplinary Warning Letters].[Warning Level]
  • Validity
  • [People Disciplinary Warning Letters].[Expiry Date]

Where Clause

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

SQL

SELECT Companies.[Company Name], People.[First Name] & \, [People Disciplinary Warning Letters].[Date Issued], [People Disciplinary Warning Letters].[Issued By], [People Disciplinary Warning Letters].Reason, [People Disciplinary Warning Letters].[Warning Level], [People Disciplinary Warning Letters].Validity, [People Disciplinary Warning Letters].[Expiry Date] FROM [Companies], [Positions], [People], [People Disciplinary Warning Letters], [Applications] WHERE (((Companies.[Company ID])=[Forms]![Frm Reports Company Dialog]![Company ID]))