Getting a list to appear in one field

[skateparkpages]

Access Problem
I have a list of items in a form that I would like to appear in a single report field but not as a list. I would like the items to appear consecutive seperated by a comma. Can any one provide a bit of code / point me in the right direction to solving this problem? Example:-

Source Info as follows:-
Hat
Cat
Mat
Rat

Report Output to be:-
Hat, Cat, Mat, Rat

Many thanks

 

[VicM]

skate

Create unbound textbox on report. In its Control Source put something like the following:

=[Field name 1st item] & ", " & [Field name 2nd item] & ", " & ..., etc.

Of course those fields need to be present in the underlying Record Source of the report. That should give you what your looking for.

HTH,

Vic

 

[skateparkpages]

Vic

The list of items are created from a query

Query Results currently reads:-
Column1 Column2
Rabbit Bunny
Rabbit Hole
Rabbit Tail
Deer Antlers
Goat Billy
Goat Horns

Want it to read after GROUP BY

Column1 Column2
Rabbit Bunny, Hole, Tail
Deer Antlers
Goat Billy, Horns

Sorry about the examples!!!!!