[AccessD] NZ for Null

In the property sheet for a text field on a Form or Report, it looks like
you would select Standard for the format, and then enter 0 for Decimal
Places.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Wednesday, June 20, 2007 10:33 AM
To: accessd at databaseadvisors.com
Subject: [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

 

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