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

cjohnson91 cjohnson91 is offline

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

« Rumba Screen Prints | Run-Time 2580 error »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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