patcurry

Also regarding my last post, I'm having some trouble with the If and Case functions. I think I'm using them right, but they won't give me a total unless I enter an additional blank record. Are there any known problems with these functions? Thanks. Pat

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