Useful Functions in Access 2007 - dummies

By Brian Underdahl, Darlene Underdahl

Part of Access 2007 Forms & Reports For Dummies Cheat Sheet

Even though Access 2007 has several built-in functions, you may not use more than a few of them in your reports. Still, if you don’t know they’re available, you could miss many of the functions that you might find really useful.

Although this list is far from comprehensive, this table shows a number of functions that you may want to use when you want a little more than just a simple sum.

Function Description
Abs Absolute value of a number
Avg Arithmetic mean
Count Number of records
Int Integer value of a number
LCase Converts a string to lowercase
Left Returns a specified number of characters from the left side of
a string
Len Length of a string
LTrim Removes extra spaces from the beginning of a string
Max Maximum value
Min Minimum value
Now Current date and time
Replace Replaces a string with a different string
Right Returns a specified number of characters from the right side of
a string
Rnd Random number
Round Rounds a number
RTrim Removes extra spaces from the end of a string
Sum The sum of values
Time Current system time
Trim Removes extra spaces from both ends of a string
UCase Converts a string to uppercase