Functions/Operators Resource needed

  • Thread starter Thread starter V. Terry
  • Start date Start date
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!
 
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
 
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.
 
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...
 
Back
Top