O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

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

Introducing Operators

There are several types of database objects and tools you need to use when you create a criterion to narrow the records returned by a query or to calculate a value. The first set of objects to which you need to refer includes database tables and their fields. For example, to calculate the subtotal of a line in the Northwind sample database’s Order Details table, multiply the Unit Price by the Quantity ordered, and adjust the total if the customer gets a discount (as noted in the Discount field). The expression to perform the first part of that calculation is [Order Details]![UnitPrice]*[Order Details]![Quantity].

Note that table fields are called out with the name of the table enclosed in square brackets, an exclamation point, ...

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