Hello

How can I assign each row of a report to a string field to make up a body text variable?

The following code only gives me the last record's details ( name and adress).

strBodyText = name1 & " " & address

I need to create a variable with all the preceding records included as well

Do I need a For loop? And how should it be structured - I only have two fields in the report Name1 and address.

Thanks

Yash

Yash,

You can use the OnPrint event of your Detail Section. Your current
syntax is fine, but you'll need to do something with each row; print
out to a file, insert into a table, or whatever.

Wayne