AND & OR Criteria

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

Queries are one of the most useful tools in a database.

They allow you to take data that has been input into the database and output information (data that has context, structure and meaning).

So far you have looked at how to create a query with a single criteria.  You can use more than one criteria in a query using AND & OR.


Information
AND Criteria

Using AND criteria allows you to search for records where two conditions have to be met.  For example, you might need to search for everyone who lives in Leicester AND are male.  In other words, city = "Leicester" AND gender="m".

Databases


Information
OR Criteria

Using OR criteria allows you to search for records that meet one or the other criteria.  For example, we could search for customers who live in Leicester OR Birmingham.  In other words, city = "Leicester" OR city = "Birmingham".

Databases


PrintIT  Print out this Page

Next  Wildcards


Last modified: Monday, 7 December 2020, 3:01 PM