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


C

cjohnson91

Joined
Aug 17, 2011
Messages
1
Reaction score
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
 
Ad

Advertisements

You must log in or register to reply here.

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access E-Mail the current record of a form in Access 2010 as PDF 1
Remain on current record after requery 1
Access Access macro build gone wrong 0
Insert Values Of External Table Into Current Data Table 0
Access MS Access - Could not update; currently locked 1
Outlook retrive current emails from outlook2003 using C# 2003 AddIn 0
Outlook Outlook 2007 Reminder Defaults Wrong 0
Access How Current page of a form Read Only 2

Top