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

Part 6. Creating Queries > Deleting Records with a Query

Deleting Records with a Query

Build a new query that contains the fields you want to search, but with no criteria entered.

Open the Query menu and choose Delete Query.

The design grid changes to include a Delete row. Set the query's criteria to return the records you want to delete (here, all records containing a Painting entry in the Product Type field).

INTRODUCTION

Suppose that you want to delete a certain product type from your inventory. Rather than deleting each instance of that product type in your database, you can use a delete query to both select the records to be deleted and then delete them.


Click the Save button on the Standard toolbar in the main Access window to save the query.

Click the Run button.

Access displays a message explaining that records will be deleted from the table. Click Yes to delete the records.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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