Use the Expression Builder
Introduction to expressions
Build an expression
Guide to expression syntax
Examples of expressions
String functions and how to use them
Access Functions (by category)
Type Conversion Functions
IIf Function
MsgBox Function
NZ Function
IsNull Function
Count Function
Round Function
InputBox Function
Array Function
Val Function
Format Function
InStr Function
Mid Function
LTrim, RTrim, and Trim Functions
Replace Functions
StrConv Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Month Function
Now Function
Weekday Function
DLookup Function
DSum Function
DMin, DMax Functions
DFirst, DLast Functions
DCount Function