Trouble with Duplicates

[JJT]

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.

 

[arickards]

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).]

 

[Liv Manto]

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).]