[AccessD] NZ for Null

Hi Virginia,

varValue = Nz(varValue,0)

OR

sngValue = Nz(qry_nonpurchase!SumOfUnits,0)

OR

Nz(tbl_InventoryCurrent!Units,0) - Nz(qry_nonpurchase!SumOfUnits,0)
-Nz(qry_purchase!SumOfUnits,0)


Look up NZ in Access Help - it gives the whole story.


BOL!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Friday, June 15, 2007 10:49 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] NZ for Null

I am trying to get a beginning total - how do I check for Nz & then put
a zero in if it is Null? This will be used on a report.

 

Beginning:
tbl_InventoryCurrent!Units-qry_nonpurchase!SumOfUnits-qry_purchase!SumOf
Units

 

Virginia

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com