how to output field record separate by comma

[lolita1]

i have a table with 3 fields and i want the output on the report to be like this:

Field#1: record1,record2,record3 etc etc
Field#2: record1,record2,record3 etc etc
Field#3: record1,record2,record3 etc etc

actually the record output is
Field#1 Field#2 Field#3
record1 record1 record1
record2 record2 record2
record3 record3 record3

 

[dhookom]

You might want to check out the Query faqs. I wrote faq701-4233 and there is another solution also. Both of these describe how to concatenate values from multiple records together in one expression.

Duane
MS Access MVP