Is there a way to place like name field in the header of report 1

[lewie]

I have a report and I would like to place a list of affected areas at the top of the report. These would be one field from the query. So #1 do i need a subreport in the header and #2 how do i make a report list the names on a line one right after the other. not one record per line.
You'll have to excuse me my report skills are especially lacking.
TIA.
Lewie

 

[dhookom]

You might be able to use the generic concatenate function found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lewie]

Thanks a bunch. It worked perfectly