Re order level

S

stevoo

How can I select the records that fall in the re-order level from a
calculating field (sum in-sum out)showing the stock balance in an inventory
database?? I, m wrestling with it few days now unsuccesfully.
Thanks
 
K

KARL DEWEY

I assume that you have a table separate from stock issue/replenishment
records that includes the re-order level. Join that table with the
issue/replenishment records table on StockID and use criteria of <
[Re-order] on the Sum([On-Hand]) field.
 
Top