A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merge Multiple Reports Into One Big Report



 
 
Thread Tools Display Modes
  #1  
Old May 21st, 2004, 06:25 PM
Darren Franklin
external usenet poster
 
Posts: n/a
Default Merge Multiple Reports Into One Big Report

Each month I produce statistics reports for management. All in all there
are 20 different reports each one showing the "Page x of x" at the bottom of
each report.

As they are all binded together once printed, the paging looks strange.

Is there anyway that they can all be merged before printed so that the page
numbering is shown as 1 of 100, 2 of 100 etc?

Regards

Darren


  #2  
Old May 21st, 2004, 06:43 PM
Rick B
external usenet poster
 
Posts: n/a
Default Merge Multiple Reports Into One Big Report

If they are combined as sub reports on one big report and the the big report
is where you place your footer. This would also make it a one-click to run
them.

Rick B


"Darren Franklin" wrote in message
...
Each month I produce statistics reports for management. All in all there
are 20 different reports each one showing the "Page x of x" at the bottom of
each report.

As they are all binded together once printed, the paging looks strange.

Is there anyway that they can all be merged before printed so that the page
numbering is shown as 1 of 100, 2 of 100 etc?

Regards

Darren



  #3  
Old May 21st, 2004, 07:56 PM
Darren Franklin
external usenet poster
 
Posts: n/a
Default Merge Multiple Reports Into One Big Report

Its always the most obvious answers that go unseen !!

Many thanks Rick I will put this in action on Monday morning.

Regards
Darren
(now feeling very stupid for not seeing the obvious!)


"Rick B" wrote in message
...
If they are combined as sub reports on one big report and the the big

report
is where you place your footer. This would also make it a one-click to

run
them.

Rick B


"Darren Franklin" wrote in message
...
Each month I produce statistics reports for management. All in all there
are 20 different reports each one showing the "Page x of x" at the bottom

of
each report.

As they are all binded together once printed, the paging looks strange.

Is there anyway that they can all be merged before printed so that the

page
numbering is shown as 1 of 100, 2 of 100 etc?

Regards

Darren





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.