I have a reservation system that has reservations for particular days out of the year. But i would like to have a print out of who is staying in what month. Each reservation has a particular start day and finish day, and i would like to have a combo box for the months of the year that once selected you will be able to click a button that runs a script that collects all the reservations for that particular month and put it into a table format for printing.

For each month, you would have a script. I'll assume you want to see everyone who is staying in a particular month, even if they arrived before the month or are leaving after the month ends. Here's an example of one for January:

Conduct a find that searches for StartDay > Jan1 or StartDay <= Jan31 or EndDay > Jan1 or EndDay <= Jan31

(since they are "or", these are all separate "Find Requests")

You would then sort in order of Start Day, display a list, and print!

BTW... nice name!

Woody

HeyWoody.com