[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.