[AccessD] NZ for Null

Yes, it is.

 

 

 

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
<http://databaseadvisors.com/mailman/listinfo/accessd> 
[mailto:accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> ] 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!SumO
fUNi
ts" *is* as single value.
 
-----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
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
<http://databaseadvisors.com/mailman/listinfo/accessd> 
[mailto:accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> ] 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!Su
mOfU
nits,0)
 
 
-----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: Friday, June 15, 2007 11:49 AM
To: accessD at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
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> 
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com