Brad Marks
BradM at blackforestltd.com
Thu Aug 9 15:43:42 CDT 2012
All, I have a small report that summarizes the number of new orders by week. The report's underlying query uses "DatePart" like this. OrderWeek: DatePart("ww",[OrderDate]) Here is a small sample of what the report looks like. ~~~~~~~~~~~~ Week Nbr-of-Orders 16 333 17 355 ~~~~~~~~~~~~~ I have been asked to spell out what the start and end dates are for each week number on the report. Is it possible to derive the "Start" and "End" dates from a week number? Thanks, Brad