In queries when you want a criteria for a field that is a range of options (from 200 to 300 for example) then you can use the BETWEEN option if the range of options have a sequential order. If it's just a random list with no order, then you can use the IN option with sets.
Microsoft Access Queries Video Series
Part 1 Basic queries - [ Ссылка ]
Part 2 BETWEEN and IN in queries - [ Ссылка ]
Part 3 LIKE and NULL in queries - [ Ссылка ]
Part 4 Separate queries - [ Ссылка ]
Part 5 Grouping in queries - [ Ссылка ]
Part 6 Calculated Fields in queries - [ Ссылка ]
Part 7 More Examples of Calculated Fields - [ Ссылка ]
#MrLongEducation #Access #Query
![](https://i.ytimg.com/vi/izBy0zSXLkw/mqdefault.jpg)