How to setup a report to show start/end dates

February 28, 200520 yr

I am not sure what would be the best way to set this up.

I have a relatively simple Oncall schedule database that has 5 fields:

-Name

-Specialty

-Beeper

-Start Date

-End Date

I'd like to be able to create a report that would show the dates inbetween the Start Date and End Dates. So if they enter 2/28/05 for start date and 3/4/05 for a end date, it shows them scheduled for 2/28, 3/1, 3/2, etc...

This may not be the right forum for this and I apologize if it isn't but since this is strictly a report type thing, I though this might be the appropriate place to post.

Thanks for your help!

Chris

February 28, 200520 yr

Use two global date fields, gStartDate and gEndDate, to hold the user's selections. Create a relationship where gStartDate <= StartDate AND gEndDate >= EndDate. Use a portal based on this relationship to display the records that fall within the date range.