October 13, 200322 yr 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
October 13, 200322 yr 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
Create an account or sign in to comment