C
Craig
I have a query where I am trying to obtain a range of values
in the query itself I can enter ">1000" or ">1000 and <2000 "
But how can I do this from a query by form. I have the form field "amount"
and in the query Forms!FormName!Amount
This will not give me a result.
Instead I get an error message
"The expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expresssion by assingning parts of the expression to
variables."
is there a way to do this ?
Thanks
Craig
in the query itself I can enter ">1000" or ">1000 and <2000 "
But how can I do this from a query by form. I have the form field "amount"
and in the query Forms!FormName!Amount
This will not give me a result.
Instead I get an error message
"The expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expresssion by assingning parts of the expression to
variables."
is there a way to do this ?
Thanks
Craig