Access 2003 - Filter records to show current week returning wrong values

Access Discussion in 'Microsoft Office' started by cjohnson91, Aug 17, 2011.

  1. cjohnson91

    cjohnson91

    Joined:
    Aug 17, 2011
    Likes Received:
    0
    Hi all,

    I am having a bit of a problem with a query I am working on to display only the current week of records.

    I am using BETWEEN Date()-DatePart("w",Date())+2 AND Date()

    to filter records from the Monday of this week to the current day and my results are returning the 15th, 16th and 17th of this week like I want but also the 15th, 16th and 17th of every other month and year in my database.

    Any ideas?

    Thanks in advance
     
    cjohnson91, Aug 17, 2011
    #1

    1. Advertisements

Ask a Question

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. Access Access macro build gone wrong

  2. Insert Values Of External Table Into Current Data Table

  3. Outlook retrive current emails from outlook2003 using C# 2003 AddIn

  4. Excel Reference to text returning "0" value on second column

  5. Word How to get 'current line number' in Word VBA

  6. Outlook Outlook 2007 Reminder Defaults Wrong

  7. Access E-Mail the current record of a form in Access 2010 as PDF

  8. Remain on current record after requery

Loading...