What if you want to find data that falls between two values? For example, how do you find products that cost between $25 and $40? You use the Between … And operator. You enter the expression as though you're saying it, and the picture shows this. Between 25 and 40 returns all items that cost $25 or more up to $40.
You can also use the Between … And operator to make a query ask you for input before it runs. Keep going to find out how.