MS Access Deduplicate Values and Sum up Numbers for each De-duplicated Value

Hello,

I am new to Access and need to do a simple task that can be done in Excel with a pivot table. I need to use Access rather tan Excel because I have millions or row entries. I really hope one of the Access pros can help me.

My data in Access table looks like below where there are three columns: (1) UniqueID is a primary key and has unique records and (2) the User ID column that has duplicate records (3) Items Purchased column that have a umber of items that the user purchased.

(1) UniqueID column
1
2
3
4
5
6
7
8
9
10

(2) User ID column
345
345
980
234
980
234
345
876
980
980

(3) Items Purchased column
3
7
1
5
2
1
7
6
3
2


I need the data look like below and to perform the following actions: (1) to deduplicate User ID column and then (2) to sum up the Items Purchased per unique/deduplicated User ID.

(1) UniqueID column
1
2
3
4

(2) User ID column
234
345
876
980


(3) Items Purchased column
6
17
6
8

Thank you in advance!

Hi Alan, I am very new to MS Access. Do I understand correctly that I need to enter this query in "Home" tab >"View" > "SQL View"? I would appreciate some guidance. Thank you!

Allan, I got it! I used your sql query and it worked as a charm! Thank you so much!