Delete Query

Hi Rachel

To delete records from a single table, or from tables with relationships, first create a new query containing the tables that you want to use (eg Products and Suppliers), Then:

1. In Query Design view, click the Delete Query button in the Query Type section. This adds a delete line to the query.

2. Drag the asterisk (*) from the tables you want to delete records from (Products) to the design grid. The word From appears in the Delete cell.

3. Drag the fields that you want to use as criteria to the design grid. For example, if you want to delete all records of Products from California from the product table you should drag the State field from the Suppliers table to the grid. The word Where appears in the Delete cell.

4. In the criteria cell type the criteria that you want to delete. In this example, you would enter "California"

However to use a lookup value in place of