Create a delete query
Dan Holme
October 30, 2007
1 Min Read
Before creating a delete query, create a select query with the * field (representing the entire table) in the first column, and any fields you need for deletion criteria in additional columns. Enter the criteria and run the query as a select query to ensure that Access is locating all desired records and only desired records.
From the query design view, choose Query → Delete Query.
Before you run the delete query, it would be wise to back up the database. Then run the query. Access will let you know how many records you are going to delete.
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like