Parameterquery; how to use operators like > and <

[Sing]

I've a in my database a simple table for ledlights. One of its fields is Type; another field is Power (W). The last field is a numeric field (integer).


I made a parameterquery. In this query I noted behind Criteria: [Power?]. When I excecute the query I get the pop-up asking for Power? When I fill in 5 and OK I get what I want. A nice list with all 5-W ledlights. So far so good.
However, when I fill in >5 and OK, the parameterquery doesn't work. In my language I get a message that this expression wasn't correctly typed or that this expression is too complex for evaluation. The helppage informs me with an errorpage 3071.
What am I doeing wrong?

[CJ_London]

you can't include the operator in the parameter in this way. Instead use the eval function in a new column e.g.

which:Eval([Power (W)] & [Power?])

and set the criteria to <>False. You don't need to see the column in the results to untick the show option.

You will get errors if you try to enter a non numeric value.

you can also enter more complex requirements such as

'between 5 and 10'

'like *5'

Using this method is fine for development purposes, but I don't recommend it for a production application - use forms instead for the user to complete. Or allow users to use the right click menu which has similar functionality to the excel equivalent


Also be aware that Type is a reserved word and should not be used as a field name, at some point down the line you will get misleading error messages - recommend change to something more meaningful such prodType. Similarly using non alphanumeric characters in field names will also cause problems down the line. See this link https://support.office.com/en-gb/art...9-f855bdd9c5a2

[Sing]

Excellent reply;thank you!
Your bottomline note is understood.