Calculations

  • Thread starter Thread starter Natalie V
  • Start date Start date
N

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?
 
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?
Click to expand...

Fax Total should not exist in ANY TABLE.

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