I have a table that has records listed more than one time. Some of these multiple records have in the score field a zero for the score. I would like to remove all records that are in the table more than once that have a zero for the score in the score field. Any help is greatly appreciated!
Delete query (1 Viewer)
- Thread starter jamphan
- Start date
CraigDolphin
GrumpyOldMan in Training
- Local time
- Today, 06:57
- Joined
- Dec 21, 2005
- Messages
- 1,582
use the find duplicates query wizard to make your query. Then put 0 as a criterion in the score field. This will show all the records that are duplicate with a 0 in the score field. Now, I'll leave it up to you to decide which records that are returned by that query that you want to delete. Bear in mind that all instances of the record with a 0 in the score field will be shown so if you delete all the records returned, and both instances of the record have a 0 in the score field, then you will be deleting both the first and second of the duplicate records.
