In the Access 2003 app that I developed the user does not want to summarize resullts by specific date but instead wants them summarized by week.
I wrote a function to return the week of a particular date for 'passedDate'
getWeekOfDate = DatePart("ww", passedDate, vbMOnday)
It works well and the results are summarized by week. Now the user has requested to see the week ending date of the respective week shown on the resultant report.
Total Recs Week Week Ending Date
312 1 01/03/2010
461 2 01/10/2010
I don't know of any way to reverse the transition from just knowing a week and a year to a week ending date. Does anyone have ideas preferably in the form of a nifty little function that does that?