Gustav Brock
Gustav at cactus.dk
Tue Sep 25 10:04:01 CDT 2007
Hi Arthur If parm2 is zero, Nz will return zero if parm1 is Null. So parm2 is something else ...? /gustav >>> fuller.artful at gmail.com 25-09-2007 16:58 >>> I've got a form that opens when you click a button. Two of the columns are calculated. They use Nz(parm1, parm2) and I would think that this results in zeros in both cases when I am adding new rows, but instead they both come up with #error, which is unbeautiful. What am I doing wrong? TIA, Arthur