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  

Hard Report Challenge 2 reports on one page



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2006, 02:49 AM posted to microsoft.public.access.reports
Please help me..
external usenet poster
 
Posts: 8
Default Hard Report Challenge 2 reports on one page

I have to create a report that show children added each month on top and
children dropped each month on bottom. I did this by grouping on status:
works fine. however I need the page to display 10 rows for added and 10 rows
for dropped. Did this with Duane Hookums help. Problem if there are more
than 10 records for either added or dropped I need to a new page identical to
the first with 10 rows for added at top with or with data and 10 rows at
bottom for dropped with or without data. Example if I have 14 dropped I need
a new page with 10 blank rows at top and 10 rows at bottom filled with 4
records.
  #2  
Old June 26th, 2006, 03:59 AM posted to microsoft.public.access.reports
Larry Linson
external usenet poster
 
Posts: 3,112
Default Hard Report Challenge 2 reports on one page

"Please help me.." wrote

I have to create a report that show children
added each month on top and children dropped
each month on bottom. I did this by grouping
on status: works fine. however I need the page
to display 10 rows for added and 10 rows
for dropped. Did this with Duane Hookums help.
Problem if there are more than 10 records for
either added or dropped I need to a new page
identical to the first with 10 rows for added at
top with or with data and 10 rows at bottom
for dropped with or without data. Example if
I have 14 dropped I need a new page with 10
blank rows at top and 10 rows at bottom filled
with 4 records.


Sounds as if somebody thinks that the old forms done on a manual typewriter
were divinely inspired. It's been a few years since I encountered anybody
quite that stodgy, who wouldn't listen when I pointed out that there was
nothing sacred about the old way.

I'm sure what you want could be done, with enough time and effort, but it
would be better to do it in a logical way.

Have you asked _why_ it is _necessary_ that there be 10/10?

Larry Linson
Microsoft Access MVP



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
I cant get my report to fit on one page rmoritzky Setting Up & Running Reports 16 February 10th, 2009 01:35 PM
Want to start page 1 numbering after five pages - how? RM Page Layout 6 April 5th, 2006 05:07 AM
Page footer with Report footer Steve Setting Up & Running Reports 0 March 3rd, 2006 05:02 AM
Reporting subreport total on main report BobV Setting Up & Running Reports 22 November 1st, 2005 03:19 AM
Printing Reports Access 2002 Pleas Advise Dermot Database Design 12 October 5th, 2005 11:23 AM


All times are GMT +1. The time now is 11:45 AM.


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