Report on multiple queries

[Pvarga]

Can you make a report that pulls data from more than one query?

 

[fernin8r]

Well... you can us a DLookup for the control. look for it on Help

 

[David R]

Or make a subreport that pulls from the other query.

Or combine multiple queries into one to use as Record Source, but that's probably not what you had in mind.

 

[Rich]

You could use subReports too

 

[Pvarga]

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]

Since the counts are independent, make separate subreports for each of them.

 

[Pvarga]

Okay thanks I will look it up.

Ashamed to say I do not know how.

Tricia