Dupe records?

[JAYLO]

Good day,
I have a table (115000 records) that might have dupes in one field. How can I find out?
And if so, how do I delete the dupes?

-J

 

[NateO]

Howdy J,

Have a looky here:

http://easyweb.easynet.co.uk/~trevor/AccFAQ/tables.htm

That's one way of approaching this. The other is to leave your original data and create a make-table query. In the design view, click on properties (make sure you don't have a field selected (click in the gray area hosting the tables), and select yes for the unique value field.

Hope this helps.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-12-19 17:03

 

[Russell Hauf]

To find out if you have Duplicates, go to your Queries tab, click on New query, then use the Find Duplicates wizard to see if you have any. Then you can use the method above to delete them if there are any.

HTH,

Russell