In Access query criteria is essential for a strong Access database. Use this query criteria quick reference guide for Access help.
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.