sysdate query in ms access

Discussion in 'Access Queries' started by sukhwinder, Dec 3, 2004.

  1. sukhwinder

    sukhwinder Guest

    how could i return the system date by the use of query in ms access
     
    sukhwinder, Dec 3, 2004
    #1
    1. Advertisements

  2. Use built-in function Date(). It will return the system date and can be used
    anywhere in Access, not just queries.

    HTH,
    Nikos

    "sukhwinder" <> wrote in message
    news:...
    > how could i return the system date by the use of query in ms access
     
    Nikos Yannacopoulos, Dec 3, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. devel
    Replies:
    3
    Views:
    110
    Michel Walsh
    Sep 18, 2003
  2. Rhonda Fischer

    => Access Query to SQL Server syntax Query

    Rhonda Fischer, Oct 21, 2003, in forum: Access Queries
    Replies:
    1
    Views:
    115
    [MVP] S. Clark
    Oct 21, 2003
  3. Mark Watkins

    Sysdate Equivalent

    Mark Watkins, Oct 28, 2003, in forum: Access Queries
    Replies:
    3
    Views:
    201
    Rick Brandt
    Oct 28, 2003
  4. Mark
    Replies:
    2
    Views:
    103
    John Vinson
    Dec 1, 2003
  5. Shaundra

    Access Query to Make Query Table

    Shaundra, Apr 16, 2004, in forum: Access Queries
    Replies:
    2
    Views:
    87
    John Spencer (MVP)
    Apr 17, 2004
  6. NUTAN
    Replies:
    1
    Views:
    87
    Michel Walsh
    Sep 17, 2004
  7. PatT123
    Replies:
    2
    Views:
    277
    PatT123
    Aug 25, 2005
  8. nikhil
    Replies:
    1
    Views:
    165
    John W. Vinson
    Aug 7, 2007
Loading...