What I have here is a client record - attached to which is pledge information, along with payment information on that particular pledge. What I would like to do is place two fields (calculated) at the bottom of my form for the pledge. The first field will calculate all of the payments made (34 possible). The second field will calculate the balance due, taking the pledge amount and subtracting the field created that totals the payments.

As there may be multiple pledge records for any one person, these fields must calculate on each record for their giving history, as well as update when new payment information is recorded.

I have both of these fields calculated in a query - but how do I get them to be placed on the form??? I did get them on there once but then no information could be entered into the record.

Thanks in advance for any and all help!

Keep them in the query.

Base your form on this query and then display the calculations.

btw what are the fields in your table ?

Kevin M