Between operator without And

Error 2430

When using the Between operator to test whether a value of an expression lies within a specified range of values, you specify the upper and lower limits of the range separated with the word "AND". For example, to test for a range of "A" to "C" code:

          WHERE MyField BETWEEN "A" AND "C"