Combining two records into one

  • Thread starter Thread starter leslie
  • Start date Start date
L

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
 
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.
 
Back
Top