M
MikeO
I apologize for re-posting but I am still having problems with calculating
certain values. The database stores units ordered, received, sold, shrinkage
in separate fields in Inventory Transactions table.
I can calculate usage, amount on hand, shrinkage etc. in a subform when I
call up each item. My problem is that I cannot get the Amount on hand to
display as a list of all items in a report or a form. I need to be able to
see what is on order at any time.
here is the expression from the subform. This displays the amount on hand
when I call up an item.
=Sum(nz([UnitsOrderedWarehouse])-nz([UnitsReceived]))
I have tried a query expression but get an aggregate error.
any help is greatly appreciated.
Mike O.
certain values. The database stores units ordered, received, sold, shrinkage
in separate fields in Inventory Transactions table.
I can calculate usage, amount on hand, shrinkage etc. in a subform when I
call up each item. My problem is that I cannot get the Amount on hand to
display as a list of all items in a report or a form. I need to be able to
see what is on order at any time.
here is the expression from the subform. This displays the amount on hand
when I call up an item.
=Sum(nz([UnitsOrderedWarehouse])-nz([UnitsReceived]))
I have tried a query expression but get an aggregate error.
any help is greatly appreciated.
Mike O.