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

This Season: Tailgating; Tech Know; New Year, New You; Tax Time

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.

Comments

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.

Follow eHow: Follow @eHow

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

Comments

Related Ads

Related Articles & Videos