Pvarga
06-24-2002, 10:26 AM
Can you make a report that pulls data from more than one query?
|
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 |