Jan's Access Tables & Queries: Action Queries

	Tables & Queries: Action Queries

An action query selects certain records and fields and then does something with them. There are four kinds of action queries:

Make-Table: Creates a new table from copies of selected records and fields. The table's records do not change when the original records change.
Append: Adds (appends) copies of the selected records/fields to an existing table.
Delete: Deletes the selected whole records.
Update: Updates values to new values in the selected records.

No Undo: You cannot "undo" an action query's action.

Verify selection first: Be sure you have selected the records that you thought you did! Use the View button to see the query's datasheet. Check the records carefully. Then run the action query with the Run button .