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:
