I was wondering if the following was possible with a query? If so, can someone give me an example query? I want to print a list of products, group them by color, and then have the totals at the end of each group.
| Color | Product |
-------------------
| Blue | Case |
| Blue | Vase |
| Blue | Coat |
Total: 3
| Red | Care |
| Red | Cover |
Total: 2
Jump to PostNot with a single query.
If anyone has another solution, or if the answer is just plain no or can't be done, I would be ok with that answer as well.
Not with a single query.
@pritaeas thanks.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
