Question

What is the difference between 'criteria' and 'or' cells in query design window of MS Access?

Answer 1

in criteria we can specify something like we do sorting but criteria makes another table for the sorted data. or is used in case if we need to specify the data on two criterias.

Answer 2

The difference between 'criteria' and 'or' cells in query design window of MS Access are given below.

Criteria cell:

It is a condition that depends upon the values in the table in which you want to apply or your specific requirements. Some criteria are easy which is uses constants and basic operators.

Example:

>25 and <50  

It is applied to a number field such as price or age. This gives the values which is greater than 25 and less than 50.

OR function:

It is an operator that has two possible values for a variable that is expressed in the form of True or False.

Example:

City = "Chicago" OR “Florida”

If anyone of the given condition is true or both are true in the table that will show the results to you. Otherwise, it will display the Null value to you.