Hi,
i have an inventory program in access,
i want a report that show balance only for items in stock, but the formula i did is this: =Sum(nz([UnitsReceived])-nz([UnitsSold])-nz([UnitsShrinkage])) but i notice when i print the report that what it gives me is the in and out transcations so for example toilet paper 6 in 3 out so it minus and give 3 balance but it does not add to the previous balance.
how may i get the real balance by products?
thank you
i have an inventory program in access,
i want a report that show balance only for items in stock, but the formula i did is this: =Sum(nz([UnitsReceived])-nz([UnitsSold])-nz([UnitsShrinkage])) but i notice when i print the report that what it gives me is the in and out transcations so for example toilet paper 6 in 3 out so it minus and give 3 balance but it does not add to the previous balance.
how may i get the real balance by products?
thank you