francodhs
asked on
Report with Multiple Pages via Search Box
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
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
How good are you with VBA?
ASKER
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.
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
...You will have to take the sample I post and modify it to work in your database.
Access-EEQ27246393SubReportsGrou.mdb
ASKER
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
Landing-Rights-Program-w-Changes.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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
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
ASKER
Thanks Jeff. Your the man!
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
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
ASKER
Copy. I just posted another unrelated question for you experts. :)