finding on multiple items

[mleiser]

This is a hard one, especially to explain. We have a day camp. Campers come for either the whole summer, only july, only august, the 1st 6 weeks (july and 2 weeks in august) or the 2nd 6 weeks (2nd 2 weeks in july and whole of august). I need a report where the data shown in each report is the same, so only 1 layout with variable heading will do. I need to choose which reprot I want. It can be for the 1st 2 weeks in july, the 2nd 2 weeks in july, the 1st 2 weeks in august or the 2nd 2 weeks in august. There are 3 types of reports possible for each of those - all campers in that time period, only the additions in those 2 weeks (only possible for 2nd 2 weeks in july or 1st 2 weeks in august), or only the deletions (possible only in 1st 2 weeks in august or 2nd 2 weeks in august). Finally, these reports are actually transportation reports so we have a final choice of all buses, or choose which bus color to report on within the above possibilities. I tried to set up 3 global fields, one for which 2 weeks, one for which type of report and one for bus color. I was going to use these values in a script and choose based on all the possibilities. So I was wondering how to do this find and script. I created a table with a record for each of the possibilities, like 1 record for 1st 2 weeks in july and all, 1 record for 2nd 2 weeks in july and all, next for 2nd 2 weeks in july and additions, etc. I'm going crazy on how to accomplish this. I decided to try to explain it. If anyone has any idea what in the world I'm talking about, and then possibly have a solution - HELP!!!!

[comment]

It seems you should have a StartDate and an EndDate for each camper - either directly in their registration record, or in a related Program record. Then searching for the right records would become rather trivial.