• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Deleting Table Records Using a Delete Query

Deleting Table Records Using a Delete Query

A delete query is an action query that deletes records in the selected table.

To start a delete query:

1.
Create a query containing the records you want to delete.

2.
With the query open in Design view, choose Delete Query from the Query Type pull-down menu (Figure 34.29).

Figure 34.29. Choose Delete Query from the Query Type pull-down menu.


or

Choose Delete Query from the Query menu.

3.
Specify all (*) for each table from which you want records deleted (From) and then specify the field and the criteria for deletion (Where) (Figure 34.30).

Figure 34.30. The query deletes records that contain a Location of 6.


In the figure, the query deletes records that contain a location of 6.

4.
Click the Datasheet view button to see the records that will be deleted.

5.
Click the Design View button to return to Design view.

6.
Run the query.

7.
Access gives you an opportunity to change your mind. Click Yes to continue.

The records will be deleted from the table or tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint