SUm duplicate values then delete duplicate rows

[DonKaponne]

I have 4 columns in my table (tblAccounts). I am trying to find any duplicates that may exist in Col A (Name Account Number), sum values in Col D (Name Account Value), then delete the entire row. So far my sheet before.



Col A
100
101
102
105
100
101
102
105

Col D
5
4
2
4
1
2
3
1


After my code is run, I need for my spreadsheet to look like this
Col A
100
101
102
105

Col D
6
6
5
5

Do someone has any idea how I can implement it?

Thanks a lot in advance

[June7]

This as been asked and answered in another thread. https://www.accessforums.net/queries...ble-46874.html

Do an aggregate (GROUP BY) Totals query. Use query designer. Access Help has more guidelines on using the query builder.