Hey, where you've written "[between] x and x" you need something like:
Code:
> [Enter First Range] AND < [Enter Second Range]
Sorry, haven't used access in a while myself but give that a go, if it doesn't work post back and i'll fire it back up (useless software tbh) and give it a proper in depth go.
Cheers,
Jamey