[MS_AccessPros] Week ending on Monday

 

I'm writing an Access report showing data grouped by week, with the week
ending on Monday. I was able to successfully accomplish the grouping
I'm looking for using week number. Now my challenge is figuring out how
to label the group footers. I want to add a label that say's something
like "Week ending 8/6/2012" instead of "Week ending 32". My question
is, how can I convert a week number into an actual date?

Thanks,

Troy Sherven

MCD, Inc.

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___