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.