Add Text Together for Report

[BMac]

I tried to search for this one but not sure how to word it.

What I am trying to figure out is how to make a report that adds all the text
from a query together and displays it in one field.

For example:

I have a table that gets me the following data.

deconid logdate log
14 12/06/2007 This is just a test
14 12/07/2007 yes.. This is a log
14 12/08/2007 Yet a log number three
14 12/09/2007 This is number 4

I would like it to display this data in a report like this:

With DeconID 14,

"12/09/2007- This is number 4 ~ 12/08/2007- yes.. Yet a log number three ~
12/07/2007- yes.. This is a log ~ 12/06/2007- This is just a test"

Is that possible? If so how? I can't seem to find anything that will add
text together like that from a table with the data on different rows..

Thank you all for your help!

 

[Al Campagna]

BMac,
If I understand correctly... a calculated field (ex. LogConcat)
= LogDate & " - " & Log
would create the concatenated string of...
"12/09/2007 - This is Number4"

Now make the report a multi column report (ex. 3 or 4 cols), select
Across then Down, and that calculated field will run out horizontally.

With 3 cols...
LogConcat14-1 LogConcat14-2 LogConcat14-3
Log Concat14-4

Use the ForceNewRoworCol = AfterSection
to go to a new line to start printing more DeconIDs
LogConcat14-1 LogConcat14-2 LogConcat14-3
Log Concat14-4
LogConcat15-1 LogConcat15-2..... etc
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."