Query: Qry Append Default Regret Reasons to Job Code
Type: Delete
Has Parameters: Yes
Has Joins: No
Has Subquery: No
Tables Referenced
- Regret Reasons
- Regret
Columns Selected
- [Regret Reasons].[Regret Reason ID]
- [Forms]![Frm Add and Edit Job Code]![Job ID]
Where Clause
((([Regret Reasons].[Always Include])=True))
SQL
SELECT [Regret Reasons].[Regret Reason ID], [Forms]![Frm Add and Edit Job Code]![Job ID] FROM [Regret Reasons] WHERE ((([Regret Reasons].[Always Include])=True))