Calculated field

[mags]

How do i create a calculated field in a table,

I want the balance column to reduce when enterinig a withdrawal and increase when entering a deposit

Many thanks

 

[jdraw]

Don't store a calculated value.
Use transactions. additions/deletions and calculate a value when needed.

 

[Alansidman]

Calculations should be done in queries and forms. Not in tables. Here is a sample db that shows how you can do it. You will need to download both files to the same directory for it to open properly.

Alan