Looking up data by WEEK of year.

[sladewilson]

I need to be able to query my database for sales each week. I am trying to set up a system to invoice certain customers on a weekly basis. I'm not much on doing dates in databases so any help would be greatly appreciated. I know I could simply tell the database which dates to start and end at but I thought I read somewhere that there was a way to query Access using a Date() type function - something that would query each week without me having to update a date range manually.

 

[PHV]

Something like this ?
WHERE Format([date field],'yyyyww')=Format(Now,'yyyyww')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886