Thread: date expression to bring up a weeks worth of records
View Single Post
  #2  
Old November 27th, 2006, 05:45 PM posted to microsoft.public.access.queries
kingston via AccessMonster.com
external usenet poster
  
Posts: 620
Default date expression to bring up a weeks worth of records
Use a Between criteria with the function Weekday():

Between [InputDate]-Weekday([InputDate])+1 AND [InputDate]+7-Weekday(
[InputDate])

Chris wrote:
i have my new data base built but for the love of god can i get the
expression right this.

in my query i need, when prompted it asks for a date, and when i put in
21/11/06, i want it to bring up all records for that week( monday to sunday).
can anyone 1 help plz.

Thank you.

Chris

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200611/1