[AccessD] Need to derive the "Start" and "End" dates from a "DatePart Week Number"

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    



More information about the AccessD mailing list