Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

ms access sql language reference

Discussion in 'Information Technology' started by jherman, Nov 16, 2005.

  1. jherman

    jherman
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. David Lloyd

    David Lloyd
    Expand Collapse
    Guest

    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.


    "jherman" <jherman@xteric.com> wrote in message
    news:1132057046.577010.111130@g44g2000cwa.googlegroups.com...
    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
     
  4. giorgio rancati

    giorgio rancati
    Expand Collapse
    Guest

    Hi,
    you can start with Sql for Access 97
    ----
    SQL Language Reference
    http://msdn.microsoft.com/archive/d...e/en-us/office97/html/output/F1/D2/S5A318.asp
    ----
    and continue with
    ----
    Fundamental Microsoft Jet SQL for Access 2000
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp
    ----

    bye
    --
    Giorgio Rancati
    [Office Access MVP]

    "jherman" <jherman@xteric.com> ha scritto nel messaggio
    news:1132057046.577010.111130@g44g2000cwa.googlegroups.com...
    > 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
    >
     
  5. jherman

    jherman
    Expand Collapse
    Guest

    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
     
  6. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    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.

    --
    Brendan Reynolds

    "jherman" <jherman@xteric.com> wrote in message
    news:1132062795.864587.235880@g49g2000cwa.googlegroups.com...
    > 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
    >
     
  7. Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    May I assume that changedate() is an SQL Server function? If so, what does
    it do? What return type is it?

    --
    Lynn Trapp
    MS Access MVP
    www.ltcomputerdesigns.com
    Access Security: www.ltcomputerdesigns.com/Security.htm
    Jeff Conrad's Access Junkie List:
    http://home.bendbroadband.com/conradsystems/accessjunkie.html



    "jherman" <jherman@xteric.com> wrote in message
    news:1132062795.864587.235880@g49g2000cwa.googlegroups.com...
    > 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
    >
     
  8. jherman

    jherman
    Expand Collapse
    Guest

    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
     

Share This Page