Free E-Books

In computer terms, an expression is generally composed of a combination of
symbols, operators, numbers, strings, or identifiers that represent a numeric
or string value. The expression is a representative object that Access uses to
interpret something and, based on that interpretation, to obtain specific
information. Simply put, an expression is a term or series of terms controlled
by operators. Expressions are a fundamental part of Access operations. They
are used to perform a calculation, manipulate characters, or test data.
ON the CD-ROM
443
IN THIS CHAPTER
Building expressions
Using built-in VBA functions
Referencing Access objects
within expressions
Using DLookup to look up data
quickly
Using Expressions in Queries
and VBA Code
You use expressions in Access to accomplish a variety of tasks. The same expression may serve as a
WHERE clause in a SQL statement, as a filter for a form or report, or in VBA procedure.
Expressions establish criteria for a query, or filter, control macros, and perform as arguments in
user-defined functions.


Pages:
920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944