Parameter Query

[patriot76]

Hi

I want the user to put in value in the pop up box, but I can't get the inequality to work.

The box says Enter < Wky Qty. Example if I enter a 10 the query only return data that only has 10 not all the data less than 10?

I want to show data that is less than or greater than.

 

[BillHesson]

try this in your criteria

<=[prompt]

 

[patriot76]

Parameter query

Bill

Works great!

Thanks much

patriot76