ms access sql language reference

  • Thread starter Thread starter jherman
  • Start date Start date
J

jherman

long time sql server user frustrated with access sql syntax
Where can I find a language reference for access - NOT vba but instead
access sql.
Thanks

J
 
For Access 2003, you can open the Visual Basic Editor, and select Microsoft
Visual Basic Help from the Help menu. In the Table of Contents you will
find a listing for Microsoft Jet SQL Reference.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


long time sql server user frustrated with access sql syntax
Where can I find a language reference for access - NOT vba but instead
access sql.
Thanks

J
 
thanks - but i can't seem to find a definition for changedate as in the
following -

select changedate(date,status)

what does this function do and where is it defined? In sql server you
can go to the help, type in datediff (for example) and a detailed
explanation of datediff pops up with usage examples etc. Am I dreaming
when I expect something similar for Access?

Thanks again

John
 
There's no 'changedate' function in JET SQL or in VBA. It must be a custom
VBA function - JET queries can call custom VBA functions, provided the query
is executed within Microsoft Access.
 
I'de like to swear at myself for not looking for that - it is a custom
VBA function (and a stupid one at that). Thanks for all the help.

J
 
Back
Top