identical records

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I have a table that has two fields and I know that some
rows are identical. I need to create another table that
will keep number of occurrence in the table. Then the new
table will have three fields, the row from source table
and a quantity field. What is the fastest and easiest way
to do this?
Thanks,
Jim.
 
Why not add a filed to the existing table.

I don't understand the problem with the duplicate records. Do you want
to get rid of them or keep them, or find them?
 
Back
Top