Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    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 asp.net and MS Access...
    Any idea
    thanx in advance...
    sajjad

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If you are using Access, why are you posting in the SQL Server forum?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2005
    Posts
    36
    thanks for reply
    bcz, sql server and ms access function almost same,at they both are microsoft product.....
    so.............
    thanx

Posting Permissions

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