I have a simple database of Employees created and I am doing queries to test it. I am doing the queries in the grid design mode, not using SQL… however I don’t know why this is happening.
I have several fields Name, Last name, Address, ZIP, City, Experience
Experience is an Integer Field and this field (numeric) is used to store the employee experience in a certain area, for example 10 would represent 10 years of experience.
Very easy to understand
Ok. I have my records and when doing the query if I drag and drop the field Experience to the grid and I put in criteria BETWEEN 5 AND 10 when I run the query I get all the records that have between 5 and 10 years of experience.
But… and this is strange…
If I put NOT BETWEEN 5 AND 10 (because I don’t want to get the records that have between 5 and 10 years of experience) then what I get is an Error…
SQL Error Code 1000
Exactly it says: syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
Why is this happening and how may I solve it?