View Full Version : list of comma separated values


robywan
06-25-2002, 05:11 AM
Hi,
I'd like to make a report about an element, putting a list of properties, not as a table, but as a list of comma separated values.
I catch data with a one field query.
I tried to make a sub-report, but could only show data disposed by columns, not as a list...
How can I show this list:
aa
bb
cc
dd

...like this?
aa, bb, cc, dd

Thanx,
Robywan

Alexandre
06-25-2002, 03:38 PM
Have alook there:

Dev Ashish - Concatenate values (http://www.mvps.org/access/modules/mdl0008.htm)

robywan
06-26-2002, 08:04 AM
Thanx a lot, Alex!
Rw