Running Total in Forms

[ignignoct5d]

I have a form that calculates number of hours each month. So a little box for Jan, Feb, etc.

At the bottom I have another field that sums it up. Well Im using just basic + to add the fields and it only works where there is something in each box.

I can't go through and put zeros in for everyone since a 0 and a blank mean two different things. I tried Dsum and just now after searching the forum, I tried nz.

Am I overlooking a real nice function that would assume a blank entry in the sum is a zero? or perhaps some trick I could try? Also, is there anyway to store the calculated total in the associated table, so I can query it later? It already has its own specific field that up until now was hand calculated and entered manually...like the monthly hours.

Thanks in advance

 

[ignignoct5d]

Thanks, I think that will work good for me. Im confused about your first statement? I have a value for each month and every person has basically 12 values (we erase/make new ones each year). And then a value for sum and such. Have I set this up wrong?

Something like

Name-------Other---------Data ------ Jan ----Feb -------Etc
Person1
Person2
Person3
etc

Thanks for all your suggestions Pat, I really appreciate them.