:confused: can some one help me? i want to know how i can find the difference between two fields in the same table,a automatically put that value in a field in that same table. Like amount due - amount paind = outstaning amount.
help anyone
thanks

... but you just don't do it that way :)

You have tables where your data is stored. Period.

You should instead make a query where the records in your table is shown, and then, still in the querydefinition, you make another field =
"OutstainingMount":([Like amount due]-[amount paind])

You don't store this in the table at all.

Sergei's code has been jumbled by the smiley. He meant this:OutstandingAmount: [Amount Due] - [Amount Paid] I agree with him 100% that this value should not be stored, just calculated. You can calculate it in a query, or in a form or report depending where you need the value.