Calculations

[Natalie V]

I set up a database with fields such as "fax", "fax
total", when I enter an amount in the "fax" field I want
the "fax total" to be automatically calculated. How do I
do this in the design view?

 

[John Vinson]

I set up a database with fields such as "fax", "fax
total", when I enter an amount in the "fax" field I want
the "fax total" to be automatically calculated. How do I
do this in the design view?

Fax Total should not exist in ANY TABLE.

Create a Totals Query based on your table, and calculate it on the
fly.