How to Sum fields from Duplicate records
Posted on 2014-09-23
I am importing Excel spreadsheets that has duplicate records (Job Numbers). The Job Number normally has only one record. However, occasionally there are corrections made to (sales) totals by using the same Job Number causing duplicate records that need to be Summed for the correct total to that record (Job Number).
How do I combine the field [sales] and leave only one record [Field: Job Number]?
I have used DSUM in a Query with some success but I need certain fields in order to have a complete report (Sales, Job Number, Customer Number, Description, Quantity, etc). As I add in the fields Description and/or Quantity the DSUM no longer works and I'm back to getting my Duplicate records. I thought that it may be the Field's Properties that was throwing it off but the Customer Number and Description are both Text and Customer Number does not hurt the Query and Description does. (FYI - Quantity is Number and Sales is Currency)
Are there other attributes that I need to look into and change? Thank you in advance.