Summing Duplicate Records

[russiver]

I have a table which contains invoice numbers in one field with corresponding invoice cost in a second field. The list contains duplicate values of invoice numbers, having different costs. To consolidate the data I would first like to sub total the costs of each invoice number and then create a new table containing unique invoice numbers in one field with there total cost in a second field.

Really scratching my head over this one. Any ideas very welcome.

 

[barbarossaii]

hi russiver,

try to group on the invoice number field and to sum the cost field in one query (in design view: group & then change setting for cost from group to sum). Then simply copy the consolidated data from the query-results into a new pre-prepared table (containing the right number of field in correct format) by 'copy & paste"

HTH,
Barbarossa II

 

[russiver]

Many thanks Barbarossa II. Simple when you know how. As you suggested I grouped by Invioce No. and summed the cost. I then saved the query as a 'Make New Table' which only contains unique invoice numbers.

Thanks again