O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding “Ands” and “Ors” in the Query Grid

If you want to construct a query with multiple criteria, you need to understand the difference between the logical operators And and Or. Although these operators can combine more than two conditions, for the sake of simplicity, let’s use just two. Start with the premise that an And operator selects records only if both conditions in a two-condition query are met. In contrast, an Or operator selects records only if one or the other condition in a two condition query are met. In other words, at least one condition in an Or query must be met.

This is where it gets a little tricky. Suppose you want to see both the Colorado and the Mississippi losses in the Losses table. You would think that you could ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required