Microsoft Office Tutorials and References
In Depth Information
Using Expression Builder
Figure 2-4:
Main
options for
creating
expressions
in a query’s
calculated
fields.
Not everything in Expression Builder is geared to creating expressions for
queries; some features of Expression Builder are better suited to creating
expressions in forms and reports. When you’re working with a query, the
main things you want to focus on are the following:
Book III
Chapter 2
Expression: This box at the top of the Expression Builder is where
operators, fields, and functions appear when you select them in the bottom
portion of the screen.
Query name: The first item in the Expression Elements list shows the
name of the query that’s open (refer to Figure 2-4). When you click your
query name, fields from that query appear in the Expression Categories
column. Clicking a field name in that center column adds the name to
the expression.
If you don’t save the query before opening Expression Builder,
clicking the Your Query Name folder in Expression Builder won’t display
anything!
Built-In Functions folder: If you click the plus (+) sign next to the
Functions folder, a couple of options appear. Click the Built-In Functions
folder to see the categories and names of available functions in the
center column. Click a category name in the middle column to display
the names of functions within that category in the right column.
Search JabSto ::




Custom Search