[AccessD] NZ for Null

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



More information about the AccessD mailing list