List of SQL functions (MS Access)

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

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" wrote in message
...
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

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" -DISCARD_HYPHEN_TO_END wrote in message
...
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" wrote in message
...
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

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

"markx" wrote in message
...


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" -DISCARD_HYPHEN_TO_END wrote in message
...
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" wrote in message
...
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