Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    18

    Unanswered: how to get result of last 5 days

    Good day

    I have table with filed "entrydate" which has records of dates from 1 aug 06 to 10 aug 06. How to see the last 5 days result. like form 6 aug 06 to 10 aug 06

    Note: I dont want the date to compare with current date date() because this is history data. also I hope to see the result with auto creteria I dont want to add the date in creteria filed manullly.

    any assistant is appreciated.

    thank you

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Use > and < in your query; use the DateAdd function to set the criteria (you can take today and add -5 days, for example).

    DateAdd is in the help file.

  3. #3
    Join Date
    Aug 2006
    Posts
    18
    Ok, thank you

Posting Permissions

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