Watch this: Specify criteria for a text field - Access

Click here to switch to other Office Online sites worldwide

United Kingdom (change) | All Microsoft Sites

	Microsoft Office Access

Search

	Word 2007 Outlook 2007
Get up to speed

	Get your business online Get help using Office 2007
Your business

	Check for free updates
Office updates

Microsoft Office Access

» Access Home

Product Information

» Overview

» Top 10 Benefits

» See it in Action

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Access 2007 Help

» Access 2003 Help

» Access 2002 Help

» Access 2000 Help

Choose your version

Training

» Access 2007 Training

» Access 2003 Training

» Access 2007 Demos

» Access 2003 Demos

Templates

» Templates for Access

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Developer Center

» Office Resource Kit

Additional Resources

» Office Marketplace

» Discussion Groups

» Access Solutions

» Access MVPs

Home > Products > Access > Access 2007 Help and How-to > Queries

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Watch this: Specify criteria for a text field

Applies to: Microsoft Office Access 2007

May 9th, 2008

Steven Thomas

Want to limit the results of your query based on the value of a text field? You can specify exact values that you want a query field to match, partial values to match, or a set of values, any one of which to match. You can also exclude results based on specified values. Watch this demo to see how to do it.

Watch this Demo button

Problems watching the video? Try our troubleshooting tips.

For a text-based article about using query criteria, see Examples of query criteria.