Query Parameter Criteria

[feedafone]

Hi,
i have a query in an acess database. the query has several parameter criteria in it. One of the parameter criterias is the cost of something. This query searchs a lists of products that have differnt prices.

I have a form linked to the query. For other fields in the query were i use parameter criteria, i have the following syntax as the criteria:

Like "*" & [Forms]![Search Product]![Name of text box] & "*"

All these parameter criteria work fine with the query, but i need a syntax for the price field in my query, where the value entered is the maximum value that should be searched.

So the text box on my form, named &quot;Price&quot;, allows the user to input the maximum price that should be searched for, all values returned by the query have to be <Price (less than). Can anyone stick a syntax up here that i could use in my query. Please this is the last stage of my database, i just have to get this done, and then tart up a few of my forms, and then i will never have to suffer the torment of this database.

Anyhelp is much appreciated

 

[GingerR]

you already have it:

< [Forms]![Search Product]![Price]

or possibly, if less than or equal to

<= [Forms]![Search Product]![Price]

 

[feedafone]

excellent,

cheers ginger