Display subform as comma seperated string

[Anna22]

Hello
I have a database which holds client information. Each client is categorised into the type of work they do. So my form displays the following:

MainForm
ClientName
ClientAddress
ClientTelNo
ClientFaxNo .. etc ..

SubForm
Category1
Category2 ... etc ...

Each client can have one or more categories assigned to them and this works fine on the screen above. However i want to create a summary report which will display something along the lines of the following

ClientName Category
Client 1 Category1, Category2, Category3,
Client 2 Category1, Category2,
Client 3 Category1, Category2,
Client 4 Category1,
Client 5 Category1, Category2,
Client 6 Category1, Category2, Category3,
Client 7 Category1, Category2,
etc ...

The only function i know that would create the lookk that i want is concatenate but i only have one field name. Is there a way of displaying this information in the format i want

Regards

Anna

 

[RoyVidar]

I'd probably have a look at dhookoms concatenation function faq701-4233. He's put up a downloadable sample at this location Other Developer's Libraries, Duane Hookom, too.

Roy-Vidar