Sum of double values with unique ID

[javeko]

Hi,

I have an file with 500.000 + lines.
Each line has an ID with an amount.
For example:
ID Amount
1 2
Often the ID appears with a different amount.

I want to have a cleaned up acces file where each ID only appears once but where the amounts are add up.

For example:



ID Amount
1 2
1 4

Should be in the new file

ID Amount
1 6

Could someone help me to solve this problem?

Thanks!

[June7]

This is accomplished with an aggregate (GROUP BY) Totals query. Actually a basic query that can be built with the query builder. Access Help has guidelines on using the query builder.

Or build a report using Grouping and Sorting features with aggregate calcs in group footer. Again, fairly basic Access functionality and Help has resources.