Calculated Field

[Poida]

Hi all

This is probably very simple to do but I just cant seem to get it to work.

I have a field that has in it a value that children have to pay for an excursion. I have another field which is how much they have paid already. I want a third field to display how much they are owing on the excursion ie Amount to be paid - Amount paid.

Have tried but as yet have been unsuccessful

Many thanx

Poida

[oilman]

hi poida

Define the third field as a calculated field and have results as a number.

subract the amount paid from the amount owe.

amount owe - amount paid

the other two fields should be formatted as a number field

Lionel