Back to Tutorial

Lesson 20: Query Criteria Quick Reference Guide

/en/access2016/how-to-create-a-find-duplicates-query/content/

Query criteria quick reference guide

Whenever you're creating a query, it's important to use search criteria that Access can understand. There are many different types of criteria you can use to search for specific terms, numbers, or date ranges. You can use our Query Criteria Quick Reference Guide below to learn some of the most common criteria. For a more comprehensive guide, look at Microsoft's official Examples of query criteria.

/en/access2016/buying-office-2016/content/