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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Where's SubReport feature

Status
Not open for further replies.
97TransAm

97TransAm

Programmer
Jul 15, 2003
2
US
If only I had a brain...

New to MS Access and I want to obtain some Sum() data with a second query on a report, but I do not have a clue on how to do this. The report is base on a main query and gets all the info I need, but there's a second query I would like to get info from and I don't see how in MS Access. I read on another post about a "subreport" but it didn't give details on how to do so. I tried to even do a subquery on the original, but fell short on how to get dynamic report data to be used by the subquery.
Any suggestions, directional kicks most welcome...
--ron
 
Sort by date Sort by votes
It helps if one turns on the graphic toolbars... found how to create the subreport. Still have a problem with getting dynamic report generated data to be used actively by the subquery. Or maybe this would never work and I should try a different tatic.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hlubpc09
  • Locked
  • Question
Want a feature similar to page numbering such as "1 of 4" 1
Replies
9
Views
121
dhookom
dhookom
yuchieh
  • Locked
  • Question
pass-through query for subreport
Replies
1
Views
66
PaulBricker
PaulBricker
glgcag
  • Locked
  • Question
SELECT TOP 3 in subreport recordsource returning no records
Replies
1
Views
32
dhookom
dhookom
houstonbill
  • Locked
  • Question
Trouble trying to filter records in a subReportQuery 1
Replies
2
Views
28
houstonbill
houstonbill
shteev
  • Locked
  • Question
Where's my hidden form gone? 1
Replies
1
Views
33
SuicidED
SuicidED

Part and Inventory Search

Sponsor

Back
Top