Nz Function Problems

[jeo]

I'm trying to create a varible in my Query which would hold a sum.
I'm using the Nz function and as soon as I hit a number that is blank, my whole total goes blank.
Here is what I'm using:
=Nz([PreTrainingInitiativesCost]+[TrainingInitiativesCost]+[PreConvSupportCost]+[PostConvSupportInHouseCost])
It only works up to the point where fields have values...
Any ideas what I'm doing wrong?
Thanks.

 

[KenHigg]

=Nz([PreTrainingInitiativesCost])+Nz([TrainingInitiativesCost])+Nz([PreConvSupportCost])+Nz([PostConvSupportInHouseCost])

???
kh

 

[jeo]

Ooops...thanks!