Creating a custom formula in an outlook form

[Scuff]

Since I got such a great answer to my last query I thought I would try again
- I am working on a custom form for a private Foundation that gives grants to
various organizations, and would like to include some formula fields.
Specifically this is what I want to do:
Field 1: amount of most recent grant (i.e. $10,000)
Field 2: total grants received (i.e. over multiple years)

So I want field 2 to automatically update from field 1. I have tried to do
this in many different ways, including having some 'hidden' fields, but I
can't seem to get it to work. I'd be very grateful for suggestions!

 

[Sue Mosher [MVP-Outlook]]

A formula can't do what you want, which is apparently to do a sum over multiple items (or the same item saved multiple times). A formula can only calculate a value based on the *current* values of other fields.