Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

rj51cxa (TechnicalUser) (OP)
26 Jun 06 7:15
I have a series of reports which give the results of individual competitions.  The are based on queries which have no common field.

I want to combine these reports into a single report so that I can analyse the data using an Excel spreadsheet.

I have tried using sub reports but, as I cannot link the sub report with the master report, this does not work.

I'm not even sure if this is possible and would be grateful for any ideas.

Best Regards
John
Helpful Member!  dhookom (Programmer)
26 Jun 06 8:26
Adding the two reports as subreports to an unbound main report should work. Why did you state that it doesn't?

Duane MS Access MVP
Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

rj51cxa (TechnicalUser) (OP)
26 Jun 06 8:51
Thanks dhookom,

The main report produces two lines of data (1st and 2nd in the competition).  I added the sub report in the Detail section of the main report and, when I ran it, I saw the results of the sub report repeated after each line of the main report.

I couldn't see anywhere else to add the sub report, hence my assumption that it was not possible.  Should I be adding the sub report in some other way?

Best Regards
John
dhookom (Programmer)
26 Jun 06 9:16
If you only want one copy of the subreport, place it in a section of the report that renders only once. This would probably be the report Header or Footer section.

Duane MS Access MVP
Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

rj51cxa (TechnicalUser) (OP)
26 Jun 06 9:36
Thanks, dhookom,

That worked - I put the sub form in the page footer.  However, this idea does not work when I export the data to Excel  - I only see the data that is in the Details section, and also, if I have more than one sub form the detail section disappears.  I'm still inclined to think I am attempting the impossible.

John
dhookom (Programmer)
26 Jun 06 10:49
I suggested the Report Header or Footer, not the Page Header or Footer. The Page sections don't resize and if your report is multiple pages, you will get multiple copies of the subreport.

Duane MS Access MVP
Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

rj51cxa (TechnicalUser) (OP)
26 Jun 06 11:09
Thanks, dhookom, that solved it.  I now have exactly what I need.

Thanks for your patience and help.

Best Regards
John

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close