What Is Criteria ? MS ACCESS CRITERIA IN QUERY ?
Table of Contents
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:
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:
- In the above query I want to sea the last_name which are equal to “hussain” so I entered that name in critirea field,
When I run the query , following result I found.
2. Not equal to “hussain”
It will show the all record which are not related or equal to “hussain”.
