O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Expressions

In an introductory Access book that I wrote, I named one chapter “It's Only an Expression.” The title might or might not have been catchy, but it certainly didn't do expressions justice. They are essential to your work in Access, and they are indispensable for finding and retrieving records in filters and queries. Whether you are using the Find command to locate a Jane in a First Name field or setting criteria with multiple conditions in advanced queries, you are using expressions to tell Access which records to retrieve.

Unfortunately for the nonmathematical, the dictionary definition of an expression doesn't offer much enlightenment: any combination of mathematical or logical operators, constants, functions, and names of fields, ...

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