Combine records on one line?

  • Thread starter Thread starter Me
  • Start date Start date
M

Me

On my report I would like to take information from each record in a
group and print it on one line. Say, from each record I want to print
the name and age of the individual in the record, and the group
contains three records the line should look something like this:

Jane Doe 23, Jim Smith 20, Will Robinson 12

Each group would start a new line and may contain a different number
of records.

Do I use some calculated field to sum the text? I tried defining a
calculated field in the query to give me the desired information for
each record like: indivInfo:[FirstName] & " " & [LastName] & " " &
[Age]
And then use a calculated field in report like: lineInfo = lineInfo &
indivInfo, but this doesn't work.

Suggestions please.....John
 
John, I have not specifically tried this, however, I would design my maain
report grouped by your groups, than create a three column subreport and
insert that subreport in the group header or footer on your main report.
Hope this helps.
Fons
 
Back
Top