Calculating Multiple text boxes

[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.

 

[John Spencer]

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

 

[Duane Hookom]

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.