Microsoft Office Tutorials and References
In Depth Information
Going beyond Basic Arithmetic
Figure 2-7:
Null fields
in a table
cause
calculations
on those
fields to be
null, too.
Figure 2-8:
The Nz()
function
in the
calculated
control
forces
Access to
use zeroes,
rather than
nulls, to
calculate a
result.
Book III
Chapter 2
If you want the third column in Figure 2-8 to show results in Currency
format ($100.00, $0.00, $0.00, and so on), enclose the entire
expression in a CCur() function, such as SubTotal: CCur( Nz([HowMany],
0)*Nz([Price], 0) ).
You can also use the IsNull() function to test for a null field. (See “Testing
for Empty Fields,” later in this chapter, for more information.)
Search JabSto ::




Custom Search