MS Access - Queries Part 2: BETWEEN and IN in queries

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 -    • MS Access - Queries Part 1: Basic que...  
Part 2 BETWEEN and IN in queries -    • MS Access - Queries Part 2: BETWEEN a...  
Part 3 LIKE and NULL in queries -    • MS Access - Queries Part 3: LIKE and ...  
Part 4 Separate queries -    • MS Access - Queries Part 4: Separate ...  
Part 5 Grouping in queries -    • MS Access - Queries Part 5: Grouping ...  
Part 6 Calculated Fields in queries -    • MS Access - Queries Part 6: Calculate...  
Part 7 More Examples of Calculated Fields -    • MS Access - Queries Part 7: More Exam...  

#MrLongEducation #Access #Query