Get totals from column containing duplicates

[David Ball]

Hi Forum,

I have a table that has a column of Equipment Numbers (e.g. CN330) and another column with corresponding costs. The Equipment Numbers are not unique. A number may appear many times in the column and the cost may be different each time. (The source data for this is an Excel spreadsheet provided by another department).

I need the totals for each unique Equipment Number but not in a "messy" format like subtotals. I need to use it as a lookup for another part of my database so want just two columns; unique Equipment Numbers in the first column and the total cost for each in the next column.

I have the unique Equipment Numbers in the first column of a new table but cant figure out how to get the total costs.

Is there a way to do this?

Thanks very much

Dave

 

[plog]

You wouldn't use a table for this. You would use a totals query: https://support.office.com/en-us/ar...-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a

 

[jdraw]

How can you identify unique pieces of equipment in your existing data? You said the numbers representing a piece of equipment are not unique, and also that the costs associated with these (non-unique numbers) vary.

Perhaps some sample raw data (current system) and desired data (new system) would clarify the issue.