Problem with Sum of

[IplayWoW]

I'm in the process of developing an Expense Report Database that is VERY similar to the preset Expense Report template of Filemaker 9...

There are repeating fields that span a period of 1 week (7 days) for a total of 24 possible repetitions.

I have everything set up fine and dandy... all of my calculations are working properly, the sum of fields, subtotals, totals, Rate per Km., etc...

So here's the problem: There is a sudden need to include the receipt number (whether it be a series of numbers or letters) somewhere to validate the expense... but because these are calculation fields it adds the receipt numbers into the totals.

Can anyone think of a way to resolve this issue without doing a drastic overhaul on my preexisting work?

I have included the FM9 Expense Report that I am referring to... My calculations are virtually the same

Expense_Report.zip

[IplayWoW]

If it would be better to establish this via a Portal & a related database, I could do that too... but I don't think that'll make it any easier.

[bruceR]

This handles part of it and may give you ideas. See yellow fields.

Expense_Report_2.fp7.zip

[IplayWoW]

I'm looking at the file now, It's perfect!

Thank you so much. I truly appreciate the help!