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

Next Video:
How to Create a Parameter Query in Microsoft Access....5

In Microsoft Access, creating a query that has multiple criteria in one field requires the use of the query design tool. Find out how to run such a query and view the results with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet


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


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!