Jul 22 2005, 01:23 AM
I currently have 3 sets of data, Former Faculty, Former Residents and Voluntary Faulty.
I have a report for each set of data (running off a query), however I need a master report with all 3 sets of data grouped by which set of data they come from. How can i do this without having any relationships (each piece of information is indepent of the other. they absolutly have no relation)
Jul 22 2005, 02:44 AM
What do you mean by grouped by which set of data they come from.
Jul 22 2005, 02:48 AM
Like for example, it will put the Voluntary Faculty in one area of the report and the Former Faculty in another area of the report. It would look just as if you printed out 3 seperate reports (one for each set of info) but combined into one report.
Jul 22 2005, 02:52 AM
Three subreports each bound to one of your queries. You do not have to establish a relationship between the queries to do this.
Just create report in design view. Put 3 subreport controls in the details section. Bind each of them to one of your queries.
Jul 22 2005, 04:45 AM
I looked up subreports in the access help section and created a new report and just draged the other reports into that new report. however it seems like the formatting is completely screwed up. The colum headers are gone. How do i make it so it looks just as if you took the 3 reports printed them seperately and pasted them togethe?
thanks for the help guys
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here