Heenan, Lambert
Lambert.Heenan at AIG.com
Fri Jun 15 11:54:00 CDT 2007
"tbl_InventoryCurrent!Units-qry_nonpurchase!SumOfUnits-qry_purchase!SumOfUNi ts" *is* as single value. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, June 15, 2007 12:34 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] NZ for Null I think that each individual value needs to be Nz'd! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, June 15, 2007 11:16 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] NZ for Null 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com