Selecting the current week

[GregginOttawa]

I've been Googling and reading for 5 days now trying to figure out how
to write a query that selects records with dates in the current week
(Sun to Sat). You'd think it would be remarkably simple (maybe it is),
but I can't find a simple answer.

If anyone could provide a relatively simple method, I would very much
appreciate it.

Thanks -

G

[GregginOttawa]

To follow-up...

This is the best I have so far. I add this as my criteria for the date
field in my query to select events during the past 2 weeks.

DateAdd("ww",-2,Date())

[Steve]

Put the following expression in the criteria of your date field:

DatePart("ww",[MyDate])=DatePart("ww",Date()) AND
Year([MyDate])=Year(Date())
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com


"GregginOttawa" <gs*******@rogers.com> wrote in message
news:11*********************@v46g2000cwv.googlegro ups.com...

I've been Googling and reading for 5 days now trying to figure out how
to write a query that selects records with dates in the current week
(Sun to Sat). You'd think it would be remarkably simple (maybe it is),
but I can't find a simple answer.

If anyone could provide a relatively simple method, I would very much
appreciate it.

Thanks -

G

[StopThisAdvertising]

"Steve" <no****@nospam.spam> schreef in bericht news:gx****************@newsread2.news.atl.earthli nk.net...

--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
re******@pcdatasheet.com

--
To Steve:
Over 500!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

[CDMAPoster]

GregginOttawa wrote:

I've been Googling and reading for 5 days now trying to figure out how
to write a query that selects records with dates in the current week
(Sun to Sat). You'd think it would be remarkably simple (maybe it is),
but I can't find a simple answer.

If anyone could provide a relatively simple method, I would very much
appreciate it.

Thanks -

G

In a prior thread, Wayne Morgan noted that:

Date() - Weekday(Date()) + 1

produces the date of Sunday on or before Date().

A version that is less cozy with the implementation of dates is:

DateAdd("d", 1 - Weekday(Date()), Date())

The following Saturday is:

DateAdd("d", 7 - Weekday(Date()), Date())

This will work for finding the current week for dates in the past and
future as well.

James A. Fortune
CD********@FortuneJames.com