Show All

Delete data from a queried database

Caution  Once you delete a record from a database, it is permanently deleted from both the result set and the database.

1. On the Records menu, make sure the Allow Editing command is checked.

   In some instances, Microsoft Query will not allow you to change the data. If the Allow Editing command appears dimmed or Microsoft Query displays a message when you click the Allow Editing command, you can't change the data. For more information, click .

2. Select the entire record you want to delete by clicking the square to the left of the record.
3. On the Edit menu, click Delete.