List of SQL functions (MS Access)

[markx]

Hi guys,

Do you know if there is some place where you can consult the (complete) list
of all MS Access SQL functions? I'm also looking for a comprehensive review
of synthax and so on...

Thanks in advance for your help on this,
mark

 

[Jeff Boyce]

Open a module and use Access HELP. Search for SQL.

The listing on Microsoft JET ... SQL Reserved Words may be a start for
you...

Jeff Boyce
<Access MVP>

 

[markx]

Thanks Jeff,

In fact, I've already seen this (i.e. "SQL Reserved Words" topic) before,
but found kinda "user-unfriendly"...
What I particularly regret is that there is no immediate link to the listed
functions, accompanied with quick explanations and an example of synthax
(think f. ex. about the MS Excel help, or (even better) about the excel "fx"
button (next to the bar where we write all the expressions...)).

Do you think that there is a chance to find something similar somewhere on
the net or inside the help? (I passed some thime looking for this, but
without much success...)
Thanks once again,
Mark

 

[Jeff Boyce]

If you are working in SQL-Server, there's BOL (Books on Line). You may be
able to find a reference at either the Microsoft site, or by searching
Google.com.

Good luck

Jeff Boyce
<Access MVP>