Delete records from one table or tables in a one-to-one relationship

For information on important considerations when using a query that deletes records, click .

1. Create a new query that contains the tables from which you want to delete records.

   How?

2. In query Design view, click the arrow next to Query Type on the toolbar, and then click Delete Query.
   
   
3. For the tables you want to delete records from, drag the asterisk (*) from the field list to the query design grid.

   From appears in the Delete cell under these fields, as shown in the illustration that follows.

4. To specify criteria for deleting records, drag to the design grid the fields on which you want to set criteria.

   Where appears in the Delete cell under these fields, as shown in the following illustration.

   

5. In the Criteria cell for the fields that you have dragged to the grid, type the criteria.

   For information on specifying criteria, click .

6. To preview the records that will be deleted, click View on the toolbar. To return to query Design view, click View on the toolbar again. Make any changes you want in Design view.
   
   
7. Click Run on the toolbar to delete the records.

Note   To stop a query after you start it, press CTRL+BREAK.