Duplicate field help please!

[alexei332003]

I'm having a problem and I just wondered if anyone could help,

I have a query that returns about 9000 records, and one of the fields in each record is for a telephone number. There are no complete duplicates of each record but if a record has a duplicate telephone number field I need it to be removed. Does anyone have any ideas?

 

[rainman89]

there is a duplicates query available through the wizard, and you can use that to help you find the duplicates... does the deletion need to be automatic?

 

[alexei332003]

Hi Ray,

The deletion does need to be automatic, or, rather than bringing the duplicates back then deleting them, only bringing back the first instance of a unique telephone number in the field when the query is ran and ignoring any duplicate values.

 

[GaryPanic]

careful here
what happens if you get 000 12 against 00 012 or 0 0012

 

[alexei332003]

I don't think that would be a problem as in the telephone number field there are no spaces, just a string of 10 numbers