Hi, Karl.

The only abbreviations used in the built-in functions are the names of the
functions themselves.  There's no shortcut there.  You need to study what
each one does.  For example:

ASC( ) = ASCII code associated with a character
CHR( ) = Character associated with an ASCII code
. . . et cetera.

Whenever you see a function name followed by a dollar sign, it means that
it's the version of the function that returns a string value instead of a
variant.  For example, LEFT$( ) will return a string value of the left side
of an input string, while LEFT( ) will return a variant value of the left
side of an input string.  When there's a choice of using the string version
or the variant version, remember that the string version of the functions
runs a little faster than the variant version.

That's a common complaint.  Open Access and press the <ALT><F11> keys to
open the VB Editor.  Type the built-in function name in the VB Editor's Help
window, and you'll get a much better list of possible matches to choose from
in the search results than you would from the Access window's Help.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.