Need Help Combining Records with Duplicate in some fields

S

Soumitra Belani

I am trying to combine records in an invoice table, the item number field and the upc field are duplicates but the pcs field and cases field are different. I would like to eliminate the duplicate records but have a total sum for the pcs field and cases field.
How would I do that?
 

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

Need some PWA help 0
Template with fields and premade texts.. 0
Sorting Multiple Tables 1
Page numbering with Merged Document and IF statements 1
Combining three files when middle file has sections with endnotes 2
challenging query 3
Access Query - "Duplicate Records Selected" 5
Need help finding old, outdated contacts in Outlook 365 on my PC 0

Top