Calculating Fields

[Guest]

I have a data entry form for keeping track of courses taken. I need to add a
"totals" field that adds the sum of 4 fields (CourseCost, TravelCost,
MealsCost, MiscCost). I added a text box and in the control source, added
=CourseCost+TravelCost+MealsCost+MiscCost. It doesn't work (it does work
with just two fields, however). What am I doing wrong? By the way, should I
add a calculation in the query instead? If so, what would be the correct
expression?

I am using 2003. Thank you so much for your help.

MB

 

[Guest]

Try this, adding square brackets, and adding the NZ function to replace Null
with zero

=Mz([CourseCost],0)+Nz([TravelCost],0)+Nz([MealsCost],0)+Nz([MiscCost],0)