Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book