Report formatting

[Guest]

I have 5 append queries that enter records into a table. Each query has a
field that specifies which query the record came from. The problem is some
people can be entered in more than one query, and they print out multiple
times. I would like to have a report that prints out something like below if
an individual meets query 1, 2, and 3:

Name Q1 Q2 Q3

Is there a way I can either cut down the table size by moving the multiple
"query" people into one record, or is there something I can do in the report
to have them print out on one line?


Thank you

 

[Marshall Barton]

I have 5 append queries that enter records into a table. Each query has a
field that specifies which query the record came from. The problem is some
people can be entered in more than one query, and they print out multiple
times. I would like to have a report that prints out something like below if
an individual meets query 1, 2, and 3:

Name Q1 Q2 Q3

Is there a way I can either cut down the table size by moving the multiple
"query" people into one record, or is there something I can do in the report
to have them print out on one line?

You will have to rearrange the report's record source, but
you can get the desired result using a function to
concatenate multiple values. Here's an example of such a
function:

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[Guest]

That's exactly what I was looking for. Thank you.