[AccessD] Nz() etc.

If I understand correctly you are using Nz on two variables at the same
time. I don't think you can do that. I believe you would have to do
Nz(parm1) and Nz(Parm2). Also sometimes I have found you have to force
it to zero even though that is the default. Example Nz(parm1,0)


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, September 25, 2007 9:59 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Nz() etc.

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com