How to Create a Microsoft Access Query That Uses Multiple Criteria in 1 Field

Video Transcript

"Hi my name is Chip Browne and I teach computer programming and Microsoft Office applications classes at a local business college here in Utah at Stevens Henagar Business College. I also create practice tests for Microsoft application specialization certifications. Today we are going to learn in Microsoft Office Access 2007 how to create a query that uses multiple criteria in one field. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. To create a query that has fields for which more than one criteria is being used let's go into the query design tool. To access the query design tool click on the create tab. In the other group click query design. Choose table or query. Add fields to your query, click and shift click and click and drag. Next add criteria to the field. the Centex is one value followed by the word or and the other value. This will return records that have values of one or the other criteria. Next, run the query. This is the result of the query. You can see that the records that are returned have the criteria of the one value or the other value. This is how you create a query that has more than one criteria for a field. For more information and videos visit me Chip Browne and chipbrowne.com."