Microsoft Office Tutorials and References
In Depth Information
Using Expression Builder
Using Expression Builder
Expression Builder is a tool that helps you write meaningful expressions
by using any combination of operators, field names, and functions. To use
Expression Builder while creating a calculated field in a query, follow these
steps:
1. If you haven’t saved the current query yet, do so now, and name it.
Press Ctrl+S, type a name for your query in the Save As dialog box, and
then click OK.
2. Type a new field name, followed by a colon ( ), in the Field row of an :
empty column in the QBE grid.
The QBE grid is in the bottom pane of the Design View window. For
more on this grid (and its lovely home, the Design View window), see
Book II, Chapter 2.
3. Right-click the empty space to the right of the colon you just typed and
choose Build from the contextual menu, or click the Builder button in
the Query Setup group on the (Query Tools) Design tab of the Ribbon.
Expression Builder opens, looking like Figure 2-3. Any text that you’ve
already typed in the QBE grid is already in Expression Builder.
Figure 2-3:
Expression
Builder.
The large white area at the top is where you compose your expression, as
shown in Figure 2-4. You can type and edit in that large area, using the
keyboard and all the standard Windows editing techniques.
Search JabSto ::




Custom Search