[AccessD] NZ for Null

Well you would use the Format function to do that...

Debug.Print Format(varValue,"#,0")

But don't forget that Format() returns a _string_ and is only supposed to be
used for _displaying_ data. Don't format the data and then store it in a
table: unless you _want_ to store the string representation.

Lambert

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