Summary Query Help

[dbero]

I am creating an Access report that lists activity by customer. For one of the values, I would like to concatenate the various products purchased into a string. One of my queries produces this sample result.

Product Wholesaler CountPurchased
Org Juice ABC 52
Grp Juice ABC 39
App Juice ABC 22

Org Juice DEF 333
Grp Juice DEF 553
App Juice DEF 211

Org Juice LMM 55
Grp Juice LMM 22
App Juice LMM 44

However, what I need is a a single record that groups by wholesaler the concatentated purchase counts into a single row, like the result below. Is it possible in a query to do this?

ABC O52,G39,A22 (O = orange, G = Grape, etc.)
DEF O333,G553,A211
LMM O55,G22,A44

The best result i can get to is;
ABC 052
ABC G39
ABC A22

this won't work because I need to have the wholesaler listed once for it to work in my report.

Thank you.

 

[HarleyQuinn]

This FAQ may be helpful

faq701-3499

Cheers

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886