• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Working with Queries > Using the Expression Builder

Using the Expression Builder

Remembering all of your table and field names can be difficult. If you must also remember the comparison and arithmetic operators you can use in your criteria the challenge becomes Everest-like. Rather than requiring you to work with a blank criteria line in the query grid, Access uses a handy tool called the Expression Builder that creates criteria and other expressions. The Expression Builder gives you a larger working area than the query design grid, has a list of every table and field in your database, and contains a list of all the operators you can use. Several of the more common operators are located on the Expression Builder's main interface.

In Access, an expression is a series of field names, operators, and values used to find or calculate values. The criteria "[Sales.Subtotal] > 1500" is an expression, as is "[Sales.Subtotal] ∗ .07".


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint