I have a database looking up plant information (max height(m), max width(m), and the amount of light needed [shade medium sun]) from a table.
I have linked the form to the database using
[Forms]![Form1]![light] for light needed,
[Forms]![Form1]![Height] for max height and
[Forms]![Form1]![Width] for max width
in the queries/criteria
The problem is i need to use the wildcards less than, more than, less than and equal to, and more than and equal to certain heights.
( <, >, <=, >=)
But the text box doesn't allow any wildcards so it comes up with the error:
"The expression is typed incorrectly, or is too complex tobe evaluated. E.g a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."
How do I get it to work properly, without complaining?
P.S, i have attached the database.