Results 1 to 3 of 3
  1. 03-24-2011, 07:39 AM #1
    Douglasrac
    Douglasrac is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    92

    Question Criteria to show date range

    Hi,

    I want a query that will only show records from today until 7 days ago. So 1 week ago.
    I have a field in the format dd/mm/yyyy. How to apply this criteria to the query?

    I know I have to type [Between "today" And #???#]. So, how do I express a week ago?
    Reply With Quote Reply With Quote
  2. 03-24-2011, 08:28 AM #2
    orange's Avatar
    orange
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,730
    Between Date and Date -7
    Reply With Quote Reply With Quote
  3. 03-24-2011, 03:58 PM #3
    Douglasrac
    Douglasrac is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    92
    Quote Originally Posted by orange View Post
    Between Date and Date -7
    Thank you! Perfectly working!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Date Range Parameter help!?!?
    By dkstech in forum Access
    Replies: 1
    Last Post: 01-15-2011, 11:05 AM
  2. Date Range Failure
    By goodguy in forum Queries
    Replies: 4
    Last Post: 12-30-2010, 10:22 AM
  3. Date range help!!
    By bananatodd in forum Access
    Replies: 26
    Last Post: 10-18-2010, 01:57 PM
  4. Sum of Values over date range
    By bosnian in forum Queries
    Replies: 1
    Last Post: 01-12-2010, 03:41 PM
  5. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 10:58 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums