Calculate varying value in a specified time

[patcurry]

I've got a problem and I'm not sure if I need a calculation, a script, a relationship or what..... I have records that have a code assigned, RG. If I have one RG on a given day, the total value is 5. If I have two RGs on a given day, the total value is 8. If three RGs, 11 and so on. I need to be able to run a report for a week or a month, and total up the value of the RG records. This is to calculate what parents owe for our after-school programs. If they have 2 kids staying on Monday, it's $8. If they only have 1 kid on Tuesday, it's $5. I need a weekly or monthly total of what they owe and I'm beating my head against a wall. Any help would be appreciated. I'm using FMP 4.1 on Win98. Thanks.

Pat

[Vaughan]

I assume you have one record for each day of childcare used. So, make a calculation that works out the rg for that day. Then make a summary field that does the whole week calculation when found and sorted correctly (you could use a script to generate the summary).