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

• #education
• #mister_long
• #mr_long
• #mister_long_education
• #cat
• #computer_application_technology
• #grade_12
• #grade_11
• #microsoft
• #access
• #ms_access
• #computers
• #database
• #databases
• #db
• #tables
• #caps
• #queries
• #query
• #between
• #in
• #set
• #range
• #between_and
• #options
• #field