Hello
I'm trying to concatenate fields in a report and display them. The fields
coming in from the query are like this:
A
B
C
D
E
I want to display
A
AB
ABC
ABCD
ABCDE
It seems to me the simplest way would be to concatenate the incoming field
to the existing value in a text box in the detail section of the report.
But Access wipes this field out every time so no accumulation occurs.
What's the best way to do this? Do I need to set up a temporary field in my
code?
Robert