RE: Delete Queries

Hi Lisa, Thank you for the post, welcome to the forum, to create a Delete Query follow these steps;
1. In the database window click on the Queries object and then on the New Query button.
2. In the New Query dialog box, choose Design View and click OK.
3. In the show table dialog box, select the table that contains the fields that you want to use and click on the Add button. Add any other tables you wish to use.
4. When all tables have been added to the Query Design window, click on the Close button.
5. Add the fields to the Field Row in the design grid. and specify the criteria required.
6. Click the Run Button or choose Query> Run command. This will run the query initially as a Select Query so that you can verify exactly which records will eventually be deleted from the relevant table.
7. Convert the Select Query to a Delete Query by selecting the Delete Query option from the Query Type list or by choosing the Query> Delete Query command.
8. Click on the Run button or choose Query> Run command to carry out the query. you will be given a warning, if you wish to continue click on the Yes button to delete the records or No to cancel the operation.
I hope that helps, best regards Pete.