Report formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
ReggieC said:
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?
Click to expand...


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'
 
Back
Top