When you use the Between...And operator, you must enter the reserved word And. Use the following syntax:
expression Between value1 And value2