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
