Visual Basic Code, Trying to get the Balance for a total Quantity on Hand after transactions

[Eldridge]

We are attempting to use this code to no avail. It seems we have gone over it and over it,,, just cant figure out why it does not function.. any help would be greatly appreciated.

Bal: IIf([InventoryTransactions_tbl]![QtyIn]>0,Sum([InventoryTransactions_tbl]![QtyIn]+[InventoryTransactions_tbl]![QtyonHandl]=[InventoryTransactions_tbl]![Bal])
IIf([InventoryTransactions_tbl]![QtyOut]>0,Sum([InventoryTransactions_tbl]![QtyOut]-[InventoryTransactions_tbl]![QtyonHand]=[InventoryTransactions_tbl]![Bal]))




THANKS.

[ranman256]

This should not be done with IIFs. Use an update query to reduce the inventory to the point of zero.

[andy49]

First part has 2 ( but only 1 )
Second has 2 ( and 2 )

??


Sent from my iPhone using Tapatalk

[orange]

Eldridge,

See this article by Allen Browne on QuantityOnHand
Also, if you search this forum for Quantity on Hand, I think you will find some posts that may be helpful to you.
Good luck.