Counting Volunteers

[lesterd]

I have hundreds of volunteers working in 10 schools. I have to do a report to tell how many volunteer hours are worked and how many volunteers did the work.

I have the hours worked out in a summary and then it is sorted into their proper volunteer area (senior citizen vol, Parent vol., etc) but I have a problem with how many volunteers did the work.

I don't want to count the volunteers every time they work. Once a volunteer works, I want to count it as a 1 and then ignore that volunteer every other time that person works. I still want to calculate all the hours the person works, but I don't want to count the number of times they work.

Each Volunteer has unique ID number.

I think it must be some kind of loop, but I am not good with loops.

Any help would be appreciated.

Lester

[FM_SouthAfrica]

You don't need a loop, this can be done with a relationship, i.e. you can easily get the total automatically anytime without using a script. Also lookup Identifying duplicate values using a self-join relationship in your FileMaker help to understand how this is done . . .