Keeping one duplicate

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a table with 4 coulmns. Item, Desc1, Desc2,
Code. I am sorting on DESC2 and finding many multiples.
But I want to retain the first Code value for any
duplicate DESC2 values. I have tried to create a new
table but can't seem to retain the first code value for
the multiples. What would be the easiest way to do this.
 
Dear Bob:

When you have two or more rows with the same Desc2 and different Code
values, how do you determine which Code value is the "first" one? And
what do you do with the values in Item and Desc1, which may be
different values in the rows for the same Desc2 value? If there are
different values in Item or Desc1 and you delete some rows, that
"information" is gone. So you may want to do some thinking about this
before proceeding.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top