Heenan, Lambert
Lambert.Heenan at AIG.com
Fri Jun 15 11:15:57 CDT 2007
Beginning: Nz(tbl_InventoryCurrent!Units-qry_nonpurchase!SumOfUnits-qry_purchase!SumOfU nits,0) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Friday, June 15, 2007 11:49 AM To: accessD at databaseadvisors.com 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