[AccessD] NZ for Null

Is there a way to format the number too? I want it to show 7,400.

 

 

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
<http://databaseadvisors.com/mailman/listinfo/accessd> 
[mailto:accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> ] On Behalf Of
Hollis, Virginia
Sent: Friday, June 15, 2007 10:49 AM
To: accessD at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
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