Re order level

  • Thread starter Thread starter stevoo
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab query help please 1
combining queries into 1 8
3 queries into 1 8
COMBINING QUERIES INTO 1 3
Checking values in different fields. 1
AT WITS END ON QUERY TOTAL 34
Combining 3 queries 2
combine like items in query 1

Back
Top