Okay so I have simplified the table shown quite a bit. Basically.... I need to know how many of each fruit Alice (and all the rest of the customers) has purchased without having to manually go in and find their name and add them together myself. I can get totals for total units of fruit purchased, and total units purchased for each customer. But I am having a heck of a time figuring out how to get a breakdown for each customer. Does that make sense? I would just go in and pick them out manually, but for our business we have SO many transactions it would be a nightmare to have to go in and pick them all out, and then remember to add them as we add new transactions.