Items at reorder point

[MFS]

I am looking for a simple query to tell me what is at reorder point on an inventory database. My query has the following fields...
Vendor Part Number
ACP Part Number
Description 1
Order Point
Order Quantity
Units on Hand

I will be running the Query to show a report of the inventory that is at a reorder point by showng what I have On Hand vs what the Order Point is.

[pbaldy]

Personally I probably wouldn't store the units on hand, but you should be able to use this in a query:

WHERE UnitsOnHand <= OrderPoint

[MFS]

Thanks PBaldy,

Awesome