[AccessD] NZ for Null

Hollis, Virginia hollisvj at pgdp.usec.com
Fri Jun 15 10:48:50 CDT 2007


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




More information about the AccessD mailing list