Re: Deleting Duplicate Records
You should make an aggregate query from your table. Bring down and GROUP BY every field that should be unique, then bring down the ID field and make it show the MIN. That query will show all the 'unique' IDs you want. Save it and call it 'UniqueIDs'.
Next,create a new query bringing in your table and the UniqueIDs query , link them by ID. Now you have a few options:
1. Make a new table with just the 'unique' records: In that new query, bring down all the fields from your table. Turn that into a Make-Table query and you have a new table with just the records you want.
2. Delete the 'non-unique' records: In that new query, make it a LEFT JOIN from your table to UniqueIDs. Bring down the ID field from both sources and put criteria underneath the UniqueID.ID of 'Null'. Turn that into a Make-Table query and you have a table with the records you want to delete. In a new query, bring in your initial table and the one you just created, link them by ID and delete the ones in the main table. Your main table will now have just the 'unique' records you want.