Jan's Working with Databases:

Delete Query

Home > Jan's CompLit 101 > Working with Databases > Appendix

Example: Delete Query

In the LanguageArtsClasses database an append query was used to add partial records to assist in recording the scores for an assignment. If that query was accidentally run twice, there would be duplicate records. How can we find and remove such duplicate records??

Dialog: New Query - Find Duplicates Query WizardAccess has a wizard for creating a query that finds duplications. The datasheet will show both sets of records.

Once you have created the Find Duplicates query, a little inspection of the datasheet shows where the duplicate records start. (Score ID 9619 and larger in this case.)
Query Design View: Find Duplicates - with criteria to pick out selected recordsNow we can add a criteria to pick out those records and turn the query into a Delete query.

When you run the delete query, a message appears, telling you how many records you are going to delete. There should be 92.

Icon: WarningNo undo for Delete Query.

Home > Jan's CompLit 101 > Working with Databases > Appendix

Last updated: September 17, 2012