In the query itself you simply put <5 to get the result.

But how do I pass this critera from a form?

Basicly the user enters a number in one box, and the choses "or more >", or "Or less <" from a combo.

Clicks the run button and then the qery runs showing how many items are instock with that entry.

Look at "DemoMultiSearchA2000.mdb",
there you have got =, <, >,
open Form1. I think it can help you.

umm thats confused me more, it dosent say what its doing, and the names are meaningless#

What is the problem ???

looks over complicated! Sorry im a n00b when it comes to access!

Look at VBA in Form and report.