Reorder query

[July 2009]

how to create a query that will display inventory under the re order point?
the fields are quantity and reorder the are number fields.

 

[Jeanette Cunningham]

In your query, use a calculated field to calculate the difference between
the stock on hand and the re order point.
If the stock on hand is equal to or less than the re order point, those are
the products that need to be re ordered.

You can do the calculated field like this:
Expr1:[StockOnHand]-[ReorderPoint]
In the criteria row for this field, put <=0 for the criteria

This will give you a list of products that need to be re ordered.

Replace [StockOnHand] and [ReorederPoint] with the names of columns in your
query.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia