Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pulling data from multiple queries or tables 1

Status
Not open for further replies.
pspring1

pspring1

IS-IT--Management
Jan 21, 2005
13
CH
Is there a way to get information from various queries or tables into one report?
 
Sort by date Sort by votes
Have a look at SubReports - they function similarly to SubForms, can be inserted in detail or header or footer sections, and have their own recordsource (linked or not linked).
 
Upvote 0 Downvote
im not familiar with that, where do i find these subreports?
 
Upvote 0 Downvote
You create the SubReports as stand-alone reports and then use the toolbox on report design on the main report to insert these.

Have you created Forms and SubForms before? the procedure is exactly the same.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
242
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
253
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
426
caykamanj1966
caykamanj1966
RonMcIntire
  • Locked
  • Question
Multiple images on a Report
Replies
13
Views
289
dhookom
dhookom
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
806
EwaFAMA
EwaFAMA

Part and Inventory Search

Sponsor

Back
Top