[AccessD] NZ for Null

The NZ function will substitute 0 for Null for your parameters, but the
Format(Standard) and DecimalPlaces = 0 will control how the data in the
field on the report will look.  i.e. 7400 vs. 7,400.

Give it a try - let me know how it worked.

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 2:28 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] NZ for Null

Yes, but I want to include the format with the Nz too in the query for
the report. I used the Nz and want to add the format to all that to show
the results with the comma.
 
Format this to show it all with commas.
Nz(tbl_InventoryCurrent!Units,0) - Nz(qry_nonpurchase!SumOfUnits,0)
-Nz(qry_purchase!SumOfUnits,0)

 

 
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
<http://databaseadvisors.com/mailman/listinfo/accessd> 
[mailto:accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> ] On Behalf Of
Hollis, Virginia
Sent: Wednesday, June 20, 2007 10:33 AM
To: accessd at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
Subject: [AccessD] NZ for Null
 
Is there a way to format the number too? I want it to show 7,400.

 

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