I am creating a Stock control database and need to find a way to compare the amount in stock, and the reorder level. However i don't know how to do this using a query so was wondering if anyone could help.
Cheers

Rob

In a blank field of your query, put something like: Surplus: [InStockAmt] - [ReorderLimit]

Unless I'm misunderstanding your question...

David R

If you want to limit the rows in the query to those items whose InStockAmt is <= the ReorderLevel, put the following in the Criteria cell of the InStockAmt field. Don't forget to modify the table name and field name to whatever you are using.

<= TableName.ReorderLevel