duplicate carrier number

[Guest]

In my database are all text fields. If it has duplicate carrier number I
want one, not as many as the table has “ It could have two, three, up to
five†same carrier numbers . Can some one help me with the query?

 

[John Vinson]

In my database are all text fields. If it has duplicate carrier number I
want one, not as many as the table has “ It could have two, three, up to
five” same carrier numbers . Can some one help me with the query?

Please explain the context. "I want one" - where? in a Query? in a
combo box? in the table (i.e. do you want to delete all but one record
in your table for each carrier number)?

What are you trying to accomplish?

John W. Vinson[MVP]

 

[Guest]

What the query is for: to give me all the carrier numbers in the database,
but the the duplicate.Example: if the table which has 20000 carriers numbers
has two john Vinson with the same carrier number. give me one of them. "
like the find duuplicates query wizard in access but show one number not all
of them"