Is there a way to select a week at a time from a date field? I would like to pull out say the 25th week of the year and then do another query that pulls the 24th week and them compare the 2 for sales, etc. I tried with DatePart but that didnt seem to work for me.. Thanks