Functions/Operators Resource needed

V

V. Terry

I am frequently writing query expressions that are not
easily found in any book or on any one site that I've yet
to find. I don't use sql or modules, and would just like a
comprehensive list of functions and operators available
with a definition and maybe examples of syntax.

I have checked the mvps.org site, and the Access Community
Newsgroups and still feel that there must exist a list I
can really use. I've been using access for a couple years.

Thanks so much, I have found many answers right here!
 
T

Ted Allen

Hi,

I'm not sure if you are aware, but much of the useful
help for Access is only available in the Visual Basic for
Applications (VBA) help. I believe that the function
list is one such item. The function list gives help
syntax, and in most cases examples, for all built-in
functions.

If you haven't used the VBA help before, go to the VBA
programming window by going to the modules section and
clicking "New", or by typing Ctrl+G in the database
window. Then, choose help. Under Contents, you should
see a Visual Basic Language reference, with a listing of
Functions under that.

Highlighting a function and pressing F1 in the expression
builder should also take you to help for a particular
function.

I'm not aware of third party help on these. Perhaps
others will post responses with further help.

HTH, Ted Allen
 
G

Guest

Hi Ted;
Thanks so much for the tip. I normally don't venture into
VBA, but I'll give it a try. I'm glad for this group,
usually I don't have to ask because someone already has.
 
G

Guest

Exactly what I needed; thanks again so much!
-----Original Message-----
Hi,

I'm not sure if you are aware, but much of the useful
help for Access is only available in the Visual Basic for
Applications (VBA) help. I believe that the function
list is one such item. The function list gives help
syntax, and in most cases examples, for all built-in
functions.

If you haven't used the VBA help before, go to the VBA
programming window by going to the modules section and
clicking "New", or by typing Ctrl+G in the database
window. Then, choose help. Under Contents, you should
see a Visual Basic Language reference, with a listing of
Functions under that.

Highlighting a function and pressing F1 in the expression
builder should also take you to help for a particular
function.

I'm not aware of third party help on these. Perhaps
others will post responses with further help.

HTH, Ted Allen
.
Click to expand...
 
Top