How you achieve that will depend on how the original data is stored in your table(s).
However it is likely you will need a crosstab query.
Thanks. Playing around with the crosstab query. By the time I get to the point of what I showed, there are queries upon queries upon queries. So my data structure this query runs from is flat. Basically a row for every product used by customer. Essentially the first image I put is the data structure I am running against.
Like this?
================================================== ================================================== ==========
Changing Query1 to a Totals query:
BTW, you do know that your table structure is not normalized, don't you??? "Product A", "Product B" and "Product C" is data. What will you have to do to add "Product D"??
very odd that this problem is so similar to this one
https://www.accessforums.net/showthread.php?t=79055
data is different, but problem the same. Almost looks like school stuff. Anyway, I suggested self joined tables.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Agree with Micron's analysis. I believe a Power Query Solution is the way to go.
This worked perfectly ssanfu. Before I read this, I had created a lot of crosstab queries, then pulled them all together later, but this did it in one step. Thanks very much.
Yeah my source data is garbage unfortunately, but it is from an external system so i have to cram it into this.