Skip to content

Query: SubQry Job Code Pre Appointment Documents NOT in the List

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

Tables Referenced

  • Job Code Pre Appointment Documents
  • Job

Columns Selected

  • [Job Code Pre Appointment Documents].[Job Code Pre Appointment Document ID]
  • [Job Code Pre Appointment Documents].[Job ID]
  • [Job Code Pre Appointment Documents].[Pre Appointment Document ID]

Where Clause

((([Job Code Pre Appointment Documents].[Job ID])=[Forms]![Frm View Job Code Pre

SQL

SELECT [Job Code Pre Appointment Documents].[Job Code Pre Appointment Document ID], [Job Code Pre Appointment Documents].[Job ID], [Job Code Pre Appointment Documents].[Pre Appointment Document ID] FROM [Job Code Pre Appointment Documents] WHERE ((([Job Code Pre Appointment Documents].[Job ID])=[Forms]![Frm View Job Code Pre