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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Access Query! - Merging Rows with Unique ID 0
How do I group identical records? 2
sum duplicate records in query 2
Access My Expression Contains Wrong number of arguments 0
query error 12
query column heads 2
Make duplicate Records for Wire Labels 6
Query design 1

Back
Top