I am new in access. Now I am using MS Access 2010.
Problem: I have table named customer with 6fields as follow
1. ID
2. Name
3. Received
4. Paid
5. Balance
6. Date
Field [3]+[4]=[5]
in [5] I have put a expression =[Received]-[Paid]
in view mood it showing result but not updating the table field balance. Just showing on form view
what can i...