View Full Version : Report on multiple queries


Pvarga
06-24-2002, 10:26 AM
Can you make a report that pulls data from more than one query?

fernin8r
06-24-2002, 10:34 AM
Well... you can us a DLookup for the control. look for it on Help

David R
06-24-2002, 11:02 AM
Or combine multiple queries into one to use as Record Source, but that's probably not what you had in mind.

Rich
06-24-2002, 12:17 PM
You could use subReports too

Pvarga
06-24-2002, 05:19 PM
I appreciate the replies. I will go see what I can do.
I had thought of making them all one query but I guess I do it worng. There are several questions that are answered in a form and then I do a count on each. Ex. one is Labor Status and there are 3 choices. If I use that in the first col of my query and then want to do the next which is disabilities I do not get that answer because the query id working on labor stats. and didabilities instead of handling them separately. So I have 4 queries and want them all to be on one report.

I know I need to spend more time learning about Access but for now I have to have my reports in by fiscal year end (6/30)

Thanks much

Pat Hartman
06-26-2002, 07:59 AM
Since the counts are independent, make separate subreports for each of them.

Pvarga
06-26-2002, 04:30 PM
Okay thanks I will look it up.

Ashamed to say I do not know how.

Tricia