How do I fornat this query?

[stuartkeith]

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.

 

[MStef]

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

 

[stuartkeith]

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

 

[MStef]

What is the problem ???

 

[stuartkeith]

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

 

[MStef]

Look at VBA in Form and report.