Combining two records into one

[leslie]

I have a table that has duplicate item numbers. I can
find the duplicates okay, but I need to create a single
record that includes all the quantities from the
duplicates. In other words, one item number, 12345,
shows up 3 times. One has a quantity of 5, one has a
quantity of 3, and one has 0. How can I merge them so I
have one record that equals a quantity of 8?

Thanks,
Leslie

 

[Jim/Chris]

If you want to only have one entry then copy your table
structure and use an append query, grouping on item number
and summing quantity.