Is therre a way to perform multiple finds in a script?

I have a file that contains 7 date fields per record. These fields show the date of each of the 7 events that occur for each record.

I need to report the count of each event on a monthly basis (how many of #1 this month...how many of #7 this month?)

I know I can do 7 combined finds manually, but I can't seem to figure how to script this.

Any help will be greatly appreciated

Use the New Record/Request step to create additional find requests.

Ok, but how do I establish the finds in the first (and 2nd throu 7th) place?

I tried putting a field in that had the date range (pasted from a global field), but I just got back a message stating that no field criteria had been entered. If I could just get one step to work, I could figure how to get it to repeat 6 more times.

What version are you using?

I'm using 6.0

Let me clarify - I want to do something like this:

Monthly Range is a global field containing the date range I want

There are 7 fields for dates (Date 1...Date7)

There are 7 fields for counters (Counter 1...Counter 7)

The script should do the following:

Find records where Date #1 is in the range of Monthly Range

Store the record count in Counter 1

Find records where Date #2 is in the range of Monthly Range

Store the record count in Counter 2

Find records where Date #3 is in the range of Monthly Range

Store the record count in Counter 3

Find records where Date #4 is in the range of Monthly Range

Store the record count in Counter 4

Find records where Date #5 is in the range of Monthly Range

Store the record count in Counter 5

Find records where Date #6 is in the range of Monthly Range

Store the record count in Counter 6

Find records where Date #7 is in the range of Monthly Range

Store the record count in Counter 7

Go to a layout that shows the counters

Enter Browse Mode

I thought this sounded familiar. Did you not see my response here?

No I didn't, but I will check it out and get back to you.

The reason I am back at this point is that 2 hours after I figured out my solution for this I experienced my first ever hard disk failure, and (you know what's coming) my most recent backup was 2 weeks before. I have been busy rebuilding ever since (on my wife's Mac, while mine is in the shop.) This script was my last task, and was saved because it was so difficult for me in the first dumb place.

Thanks so much, :blush:

Hi John,

Please [color:red] DO NOT Double Posts. This is just one of the reason why we insist on this. There is NO joy in trying to follow the same thread posted in two places.

Lee