report needs a csv list

N

Neal

We have a report that lists all the items on a certificate. If there is more
than one item, it simply prints one below the other. But now the customer
wants them in a list with , separators.

Eg it now shows...

Large wooden table
Black chair
Fireside rug

but they want...

Large wooden table, Black chair, Fireside rug

How do I change it so that it will do this, I have no idea.

Thanks, Neal
 
N

Neal

Thanks for your help! I got it working by following your instructions.

On thing that did trip me up was that I made a new query then tried to paste
into the line (first line of the grid) but always got a syntax error.

After a while I made a new query, switched to SQL, then pasted it in and it
worked. Kind of obvious once I did it, but not at the time.

Thanks again, Neal
 
Top