Query Criteria Quick Reference Guide-Access 2013

Below, you'll find a guide containing 20 of the most common criteria used in Access queries. While these criteria are all fairly simple, each one can help you carry out meaningful searches of your data.

When entering the criteria, write them exactly as they are written in the second column, replacing x with your search term—or in the case of dates, replacing mm/dd/yyyy with the desired date.

Simple criteria for all data types:

Simple criteria for text:

Simple criteria for numbers:

Simple criteria for dates:

Post a Comment

* Please Don't Spam Here. All the Comments are Reviewed by Admin.

buttons=(Accept !) days=(20)

Our website uses cookies to enhance your experience. Learn More
Accept !