Compiling query criteria in Microsoft Access 2019

There are many different types of criteria that you can use to querytable data in Access 2019. It all depends on the field types and outputyou require. Query criteria can consist of dates, text, functions, andso much more. The following table shows some examples and explanationsof different criteria that can be used in a query. Try these examples onthe SSGSchool.accdb file youhave been using for the topics in this chapter:

Criteria Explanation Example
Text Simple text results—for example, company or area name.

= Equal to displays query results where the amount is equal to 5000.
<>  Not equal to displays query results for all house types except Emerald.
Less than displays query results for all birth months beforeJuly.
<= Less than or equal to displays query results where the date ofpayments in the FeeAccounts table isless than or equal to June 30, 2004.
Greater than displays query results where the amount paid by parentsis greater than 7000.
>= Greater than or equal to displays query results where the enrollmentdate is greater than or equal to January 28, 2007.
Yes/No Displays query results where the child received a scholarship.
Like Displays query results where the surname field contains text thatstarts with W.
Between Displays query results between two amounts in the AMT_RECEIVED column.
AND AND criteria must be placed on the same line on the query grid.
OR OR criteria must be placed on different lines on the querygrid.
NOT Shows query results for all students except MEAKER in the case of this example.

 

In the next topic, we will delve further into query criteria,learning how to apply special characters to get the output you need whenconstructing queries in Access 2019.

Leave a Comment