I have been trying for the last few years to do something which seems really, really simple and common, but cannot figure it out. I really wish Access could become a bit more user-friendly for something as simple as this.
Here is my issue. I have a very simple report, an order report. An order sometimes may have the same item ordered more than once. Instead of showing an item occurrence more than once, I want the item to appear once, and total the quantities into one sum. Simple right? Well, not for me.
I have tried sorting by item (which works), but then set the sorting to total by Quantity. What it does is give me a count of the number of occurrences of that item, it does not total the quantities, as I asked it to.
So, how do I get the report to total "like" products, based on their quantities ordered?
Thank you!!
P.S. I have attached screen shots of my query, report, and report grouping settings.