Trouble with Duplicates

JJT

Registered User.
Local time
Today, 15:42
Joined
Jan 5, 2001
Messages
47
I have an Access 2000 database with about 1,000 records many of which have duplicated case numbers. Is the a way to create a query that will delete the records with the duplicate case numbers or create a new table with only the first occurance case numbers ?

Thanks so much.
 
Try doing this:
Copy the structure of current table into a new table and make the case number the primary key. Append the data from old to new. This will keep first record and drop all dups.

[This message has been edited by arickards (edited 09-20-2001).]
 
You could create a crosstab query - GROUP BY so you could grouped your field's data thereby supressing duplicates OR you could create a delete query.

Sample of which I am sending you a copy now.



[This message has been edited by Liv Manto (edited 09-17-2001).]
 

Users who are viewing this thread

Back
Top Bottom