Skip to content

Query: Qry Append Default Application Status Steps to Job Code

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

Tables Referenced

  • Application
  • Application Status

Columns Selected

  • [Application Status].[Application Status ID]
  • [Forms]![Frm Add and Edit Job Code]![Job ID]

Where Clause

((([Application Status].[Default Step])=True))

SQL

SELECT [Application Status].[Application Status ID], [Forms]![Frm Add and Edit Job Code]![Job ID] FROM [Application Status] WHERE ((([Application Status].[Default Step])=True))