If you want to remove records from a table based on a criterion or criteria, you can do so with a delete query . The delete query searches the table you specify and removes all records that match your criteria. Because Access permanently deletes these records, use caution before you run a delete query. You can preview the results before you actually run the query. By clicking the Datasheet View button, you can see which records will be deleted before you actually run the query.
Create a Query to Delete Records