duplicate carrier number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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]
 
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"
 
Back
Top