Microsoft Office Tutorials and References
In Depth Information
1
Create a query with a fi eld list for
the Client table.
Add the Client Number, Client
Name, Amount Paid, and Current
Due fi elds to the query.
Right-click the Field row in the
fi rst open column in the design
grid to display a shortcut menu
(Figure 2–60).
insertion
point in fi rst
open column
included fi elds
shortcut
menu
Build command
allows you to use
Expression Builder
Zoom command
allows you to use
Zoom dialog box to
enter an expression
Figure 2–60
2
Click Zoom on the shortcut menu
to display the Zoom dialog box.
Type Total Amount:[Amount
Paid]+[Current Due] in the
Zoom dialog box (Figure 2–61).
Zoom dialog box
expression for
calculated fi eld
OK button
colon separates
name of
calculated fi eld
from expression
Do I always need to put square
brackets around fi eld names?
If the fi eld name does not contain
spaces, square brackets are
technically not necessary, although it is
still acceptable to use the
brackets. It is a good practice, however,
to get in the habit of using the
brackets.
square brackets
([ ]) around fi eld
names
name of
calculated fi eld
(Total Amount)
expression
for calculated
fi eld ([Amount
Paid]+[Current Due])
Figure 2–61
Search JabSto ::




Custom Search