Full Version: Making a report with objects that have no relationship
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
musk
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)
MicroE
What do you mean by grouped by which set of data they come from.
musk
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.
fkegley
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.
musk
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.