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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. devel
    Replies:
    3
    Views:
    135
    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:
    142
    [MVP] S. Clark
    Oct 21, 2003
  3. Mark Watkins

    Sysdate Equivalent

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

    Access Query to Make Query Table

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