Running total minus current record?

[jblewis]

I'm constructing a database of daily reports. Each day's report is a new record. Field "A" in each day's report must show a running total of the numbers entered each day into field "B," but here's the catch--the running total shown in "A" needs to include all the previous days, but not the current day.

Is there any way to exhibit a running total up to, but not including the current record?

Thanks in advance for your help.

Jim

[StevenB]

Have you tried using Set Field [Field A,"Status(CurrentRecordCount)-1"]?

This would set the field to one less than the total number of records.

Hope this helps.

Steven B