Calculating Multiple text boxes

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I want to get a grand total of the sum of Mileage, Airfare, Rooms, Meals, etc.

What would the formula be? The formula in the sum of mileage is as follows:

=NZ(sum([Mileage Expense]),0)

I want to add these all together.

thanks.
 
Possibly something like the following

=NZ(sum([Mileage Expense]),0) + NZ(sum([Airfare Expense]),0) + ...

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
One method would be:
=NZ(sum([Mileage Expense]),0) + NZ(sum([Airfare Expense]),0) + NZ(sum([Rooms
Expense]),0) + ...

In a normalized table structure, Mileage, Airfare, etc would be values
stored in an ExpenseType field rather than fields.
 
Back
Top