Page 6 of 11PREVNEXT

Queries III: Use expressions and other criteria

The Between ... And operator

Find ranges of values

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.

Page 6 of 11PREVNEXT