Criteria for Multiple Fields in Query in MS Access - Office 365
When you want to limit the records based on several field conditions you do so by setting criteria in each of the fields that will be used for the scope. This video explains in detail how you can define criteria for multiple fields in query.