UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Making a report with objects that have no relationship    
 
   
musk
post Jul 22 2005, 01:23 AM
Post #1

New Member
Posts: 15



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)
Go to the top of the page
 
+
MicroE
post Jul 22 2005, 02:44 AM
Post #2

UtterAccess VIP
Posts: 4,034
From: NY - USA



What do you mean by grouped by which set of data they come from.
Go to the top of the page
 
+
musk
post Jul 22 2005, 02:48 AM
Post #3

New Member
Posts: 15



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.
Go to the top of the page
 
+
fkegley
post Jul 22 2005, 02:52 AM
Post #4

UtterAccess VIP
Posts: 23,583
From: Mississippi



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.
Go to the top of the page
 
+
musk
post Jul 22 2005, 04:45 AM
Post #5

New Member
Posts: 15



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
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 04:05 PM