How Do You Use BETWEEN In Microsoft Access SQL?
BETWEEN is useful when selecting data that falls within a specific range. Learn how to use this powerful Microsoft Access SQL keyword. Open the SQL view window. Type “SELECT” and the name of the columns you want to see. For example: SELECT employeeName, salary. Press Enter. Type “FROM” and the name of the table containing the columns. For example: FROM employees. Press Enter. Type “WHERE” and the name of the column whose criteria you want to limit. For example: WHERE salary. Type “BETWEEN” and the lowest value you want to see in your results. For example: WHERE salary BETWEEN 30000. Type “AND” and the highest value you want to see in your results. For example: WHERE salary BETWEEN 30000 AND 100000. This entire statement will return all employees with salaries of at least $30,000 but no more than $100,000. Run the query.
