PC Review


Reply
Thread Tools Rate Thread

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

 
 
New Member
Join Date: Aug 2011
Posts: 1
 
      17th Aug 2011
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count records added in current week Tonia King Microsoft Access VBA Modules 3 18th May 2010 04:55 PM
Data Access Page Group Filter Doesn't Show All Values ChrisM Microsoft Access 0 1st May 2009 10:26 PM
access 2003 join not returning expected records dbnoodler Microsoft Access Queries 5 18th Jul 2008 07:51 PM
Provide wrong filter with search query, AD returning wrong err cod =?Utf-8?B?ZGFyc2hp?= Microsoft Windows 2000 Active Directory 1 11th Jun 2007 04:44 PM
Query returning previous week's values =?Utf-8?B?Sm9obkRvZQ==?= Microsoft Access Queries 1 31st Dec 2003 12:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:38 PM.