O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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 the Elements in Expressions

An expression is a statement of intent. If you want an action to occur after meeting a specific condition, your expression must specify that condition. To select records in a query that contains ZIP field values of 90000 or higher, for example, you use the expression

      ZIP>=90000

You can use expressions in arithmetic calculations also. If you need an Extended Amount field in a query, for example, use

       [Extended Amount]: Quantity * [Unit Price]

as the expression to create calculated values in the data cells of the Extended Amount column.

Note

Square bracket pairs ([]) must enclose object names, such as field names that contain spaces or punctuation other than the underscore character. You also use square ...

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