Create a delete query

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.
  1. From the query design view, choose Query → Delete Query.
  2. 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.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.