Tables and totaling fields

[Danielle17]

Is it possible to total 4 fields in a query? I've been trying everything. What does the expression have to look like for the column that will add the other 4 columns? I have tried the following:

Sum([LodgingCost]+[MealsCost]+[GasCost]+[MiscCost]) But I get the error - Extra paranthesis. I've checked and double-checked and cannot find a extra one.

Sum([LodgingCost]&[MealsCost]&[GasCost]&[MiscCost])

What am I doing wrong on these?

 

[LarryDeLaruelle]

Danielle:

If you are doing this in a query, you don't want to use the Sum function.

Your expression should look like this

SomeName: [LodgingCost]+[MealsCost]+[GasCost]+[MiscCost])

If you don't name the field (SomeName) you will get something like Expr1 as a column header.

Hope this helps.
Larry De Laruelle
larry1de@yahoo.com