[AccessD] NZ for Null

How can I format the results to show the number as 13,000? (standard
with no decimals)

 

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