SUM or combine text fields

[mfpoore]

I have a SUM query that combines invoice amounts so that clients only get one bill for the month. I can't seem to figure out how to also combine text fields so that I can include an itemization on the invoice.
Any ideas?
Greatly appreciated,
mfpoore

 

[Rich]

do you mean separate fields or records?

 

[mfpoore]

sorry, I need to combine RECORDS so that my invoice will list all tests that a hospital is being billed for that particular month.
Need it to do exactly what SUM does, but combining text instead of numeric.

 

[Rich]

why not just use a sub report or list the records in the detail section?