This one seems to work:
IIf([QuantityOut]>=0,[QuantityIn]-[QuantityOut],[QuantityIn])
Excel Formula To Access
Who is John Galt?
Windows XP 
Access 2007
This one seems to work:
IIf([QuantityOut]>=0,[QuantityIn]-[QuantityOut],[QuantityIn])
Excel formula to access vba.
Translating Excel formula to Access formula (in query)
set excel formula from access vba
Posting Permissions
Reply With Quote