Report with Multiple Pages via Search Box

francodhs
francodhs used Ask the Experts™
on
To All:

I have a flight schedule report that contains two nested sub reports to identify two terminals.  Currently, I have a search box where the user can select a date and the schedule will reflect that date.  What I need is to somehow modify the report and/or search box to allow the user to select a date range to obtain multiple schedules as opposed to just one.  Also, each schedule would have to have the current date posted at the top so the user can simply scroll through the report and clearly identify each schedule by date.  I have included sample data for today and tomorrow.  So far, this forum has been instrumental in the success of this project.  Thx.
Landing-Rights-Program.mdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
How good are you with VBA?

Author

Commented:
Not as good as you.  I follow as best I can, but I need you guys with the shields to help me as I learn. i do use VBA for basic scripts, but due to my multitasking at work, I don't have the luxury of learning it as well as I should.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Sorry, I meant to say: "How good are you at Report Design?"

...You will have to take the sample I post and modify it to work in your database.


Access-EEQ27246393SubReportsGrou.mdb
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I modified my project based on your suggestions.  I still can't get the whole report for each day on one page.  Can you please take a look?
Landing-Rights-Program-w-Changes.mdb
MIS Liason
Most Valuable Expert 2012
Commented:
You did not replicate what I had done completely.

My report had the Force new page property set for the group footer.
My subreport had the child and master links set to "ArrivalDate".
My main Report is has a "Unique" lists of dates as the source.

Here is the revised sample back, it appears to work as specified.
Please examine it *thoroughly* to see what I have done.
(especially noting the SQL for the recordsource of the main report)

JeffCoachman
Landing-Rights-Program-w-Changes.mdb

Author

Commented:
Outstanding!  Can you please explain to me the force new page on the group footer?  I couldn't find the property setting, but everything else I understood.  Thanks Jeff.  I can always count on you guys to get me to my objective.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
If you open the report in design view, then press the F4 function key, the property box will open.
From the drop-down, select "GroupFooter n"
Then you will see the property listed.
It sets when you want the page to break with respect to this section

Author

Commented:
Thanks Jeff.  Your the man!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Just a note:
The SQL to create the unique dates may start to slow down your app as you start dealing with more and more records.

The ultimate goal might be to crete a static table of a range of dates.
Then join this with the Arrival table in such a way as to get only dates with arrivals, but this should be the subject for a separate, new question.

;-)

Jeff

Author

Commented:
Copy.  I just posted another unrelated question for you experts. :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial