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

Chapter 11. Using Action Queries > Deleting Records from a Table with an Action...

Deleting Records from a Table with an Action Query

Tip

It's a good practice to run a select query to display the records that you are about to delete and then convert the select query to a deleted query.


Often, you might have to delete records from a table. For example, you might want to delete records for canceled orders, or records for customers that have made no purchases for several years. Deleting records from a table with a delete query is the reverse of the append process. You create a select query with all fields (using the * choice from the field list) and then add the individual fields to be used to specify the criteria for deleting specific records. If you don't specify any criteria, Access deletes all the table's records when you convert the select query into a delete query and run it against the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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