You are currently viewing How To Use  MS Access Criteria In Query?

How To Use MS Access Criteria In Query?

In Database Access Query a criteria is a condition which user use to get the specific record from the table column. So in the article we discuss the top 20 common criteria about database query.

These 20 common criteria are simple, and  will help you to carry you to meaningful searches from you data. To understand more comprehensive visit Microsoft Official Employ Query Criteria.

Please read this article how to create query in MS Access.

Simple Criterial For All Data Type:

Criteria Name

Syntax (Use)

Function

Equal

"X"

Search for all values equal = x

Does Not Equal

Not in (x)

Search all values except "x"

Null

Is Null

Search Empty Field

Does Not Null

Is Not Null

Search All Non Empty values

MS Access Criteria In Query

Now we implement above criteria with the simple example of some student data which have the different enroll date and classes.

Example: 

ms access query criteria
  1. In the above query I want to sea the last_name which are equal to “hussain” so I entered that name in critirea field,
ms access criteria query

When I run the query , following result I found.

ms access criteria query

2. Not equal to “hussain”

ms access criteria query

It will show the all record which are not related or equal to “hussain”.

ms acceass criteria query

Some Of Simple Text Filter 

Criteria name

Syntax

Function

Contain

Like "*x*"

Filter all the value which is contain x. It search the Character wise.

Does Not Contain

Not Like "*x*"

Filter all the value which is not contain x. It search the Character wise.

Begin With

"x*"

Search all the values which begin with this character.

End with

"*x"

Search all the values which end with this character.

Comes After

>="x"

Search all the values which comes after with this character.

Comes Before

<="x"

Search all the values which comes before with this character