Hi,
I have a table with about 20 values which I need to get into a field at the bottom of a report. The values in the table act as a key, so I need each of the records in the table to go together into one field. Does anyone know how I can do this?
I tried to concatenate into one big string, and use chr$(13) as carriage return (so that I can have each table record on a separate line in the field), but chr$(13) just produces a symbol and includes it in the string.
Any ideas would be very gratefully received.
Many thanks
Tracy
I have a table with about 20 values which I need to get into a field at the bottom of a report. The values in the table act as a key, so I need each of the records in the table to go together into one field. Does anyone know how I can do this?
I tried to concatenate into one big string, and use chr$(13) as carriage return (so that I can have each table record on a separate line in the field), but chr$(13) just produces a symbol and includes it in the string.
Any ideas would be very gratefully received.
Many thanks
Tracy
