Skip to content

Query: Qry Care

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

Tables Referenced

  • People Care Records
  • Positions
  • People
  • Applications
  • Organisational Codes
  • Companies

Columns Selected

  • Companies.[Company ID]
  • Companies.[Company Name]
  • [Organisational Codes].[Organisational Unit]
  • People.[First Name] & \
  • [People Care Records].[Date Captured]
  • Quarter
  • [People Care Records].[Quarter Year]
  • [People Care Records].[Care Received]
  • [People Care Records].[Number Sessions]
  • [People Care Records].[Care Value]
  • Notes

Where Clause

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

SQL

SELECT Companies.[Company ID], Companies.[Company Name], [Organisational Codes].[Organisational Unit], People.[First Name] & \, [People Care Records].[Date Captured], [People Care Records].Quarter, [People Care Records].[Quarter Year], [People Care Records].[Care Received], [People Care Records].[Number Sessions], [People Care Records].[Care Value], [People Care Records].Notes FROM [Positions], [People Care Records], [People], [Applications], [Companies], [Organisational Codes] WHERE (((Companies.[Company ID])=[Forms]![Frm Reports Care Dialog]![Company ID]) AND (