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

Top