Deleting Duplicate Entries

[Kristian A Ward - www.syssol.ca]

I have a 16,000 entries that i have to go threw and delete multiple entries
and i really dont feel like going threw and deleting one at a time.

I thaught of using the distinct string but i think i may be doing in
correctly...here is an example of what im doing...

1- 0001
2- 0001
3-0001
4-0002
5-0002
6-0002
7- 0003
8-0003
9-0003

so i want them to delete them with out leaving any

any suggestions?

Kristian Ward
System Solutions
www.syssol.ca
(e-mail address removed)

 

[Michel Walsh]

Hi,


With Jet? Append the data into a new table not allowing duplicated
values. You will get error messages like xxxx records won't be appended, but
that is exactly what you want.


Hoping it may help,
Vanderghast, Access MVP

"Kristian A Ward - www.syssol.ca" <Kristian A Ward -
[email protected]> wrote in message
news:[email protected]...

 

[Kristian A Ward - www.syssol.ca]

Thank You,

What i did was i exported it into excel and did it threw there....

Thanks Again

Kristian