Dan Waters
dwaters at usinternet.com
Fri Jun 15 13:53:59 CDT 2007
Isn't this the right side of an equation with three separate variables? Quantity = CurrentInventory - UnitsNotPurchased - UnitsPurchased Or something like that! -----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:54 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] NZ for Null "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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com