Current week query

  • Thread starter Thread starter johndoe
  • Start date Start date
J

johndoe

I'm trying to return all information from a table having a
field called "service_date".

However, the data should be only from the current week,
from Sunday to the Present Day.

So lets say there are records on Monday 12/22/2003,
Tuesday 12/23/2003 and Wednesday 12/24/2003 and I execute
the query on Wednesday. It should return all the data from
12/22/2003 upto 12/24/2003.

And if I execute the query the next day, Thursday
12/25/2003, it should return the data from 12/22/2003 upto
12/25/2003.

How can this be done? Any help will be greatly appreciated.

Thanks.
 
ok, the query works fine, but would you please explain how
you figured this out? And where can I get help in
understanding how these date() features work?
 
John

I'm afraid the only way I know how to do this stuff is based on the fact
of many moons of experience of needing to figure out something similar
in my own databases.

Do you understand what the expression I gave you actually does?

I suppose it would be useful to have a look in Access Help, or in a book
which covers Functions, to familiarise yourself with the following...
Date()
Now()
Day()
Month()
Year()
DateSerial()
WeekDay()
DateValue()
TimeValue()
DateAdd()
DateDiff()
DatePart()
CDate()
 
Back
Top