Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: Get last 7 days inserted Record

    Hi All,
    i have a database, and every time when any row enter , it capture the date and time of insertation,
    then does any function or query available, which help to investigate me, today inserted record,yesterday inserted record,last 7 days inserted record,last 30 days inserted record and last year inserted record..
    i am using and MS Access...
    Any idea
    thanx in advance...

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Have a gander at the dateadd() function, it will get you where you want to go.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts