null/zero calculation

[romanticode]

i have database, my old database use blank, the new one use "0" (zero) on empty field, let's call "num" field. when i do calculation, it doesn't return any value (both on zero/empy). I use "-" (mines) calculation.

So far i save it on excel and use excel formula to do the calculation.
How i can solve this problem?

thanks

 

[Ron_dK]

You might do a search on Nz function in this forum.

Hth