Concatenating in reports

[Ben McCall]

I have a database in access 97.

I have one field in each record which I would like to place in a report. I would like to place each field on a page sequentially instead of having each field on a separate line.

The setup of the information is as follows:

Record 1-field (answer)
Record 2-field (answer)
Record 3-field (answer)
Etc

So I would like to have in my report the following:

Record 1-field (answer) Record 2-field (answer) Record 3-field (answer) etc

If each of these fields were in the same record I could accomplish what I require by concatenating the three fields. I have been unable to figure out anyway to concatenate fields in sequential records. Is this possible?

Is there any way to use a recordset to label these fields and thereby be able to concatenate them?

Or is there any other solution to my problem?

Thanks!

Ben McCall

 

[dhoffman]

You might be able to create a temporary table where the fields represent the answers to each question. You would have to use VBA to run through the original table (actually you would want to use a query, not your actual table) and for each answer make a field in the new table. If you were only printing one patients report at a time you could go ahead and write the answers to the new table as you created the fields. Otherwise you may need to make another for loop that creates a query for each patient and for each of those queries updates the new table with the answers. It could be a lot of work but I'm sure it is feasible. Do you think that these ideas might help you at all?

 

[Ben McCall]

I had hoped for somehting simpler but yours may be the only way.

Thanks!

Ben McCall

 

[KevinM]

If you want each record on a different page then simply add a page break after the field.

HTH