AND & OR Operators

The AND operator displays a record if both the first condition and the second condition is true.

The OR operator displays a record if either the first condition or the second condition is true.

Examples:

Combining AND & OR:

You can also combine AND and OR (use parenthesis to form complex expressions).

Example: