Show actual date range instead of week number 1

[netrusher]

When using the Format:'yyyy mm dd' in access queries.
When trying to show a week is there a way to show the
date range instead of week number.

Week 01 = Jan1-7. If the results are only week numbers
that makes it hard for people to understand when it
actually is. Bottom line is: I would like to convert
Week number to actual date range. Can anyone help with
this?

 

[Remou]

Here you go:

http://www.tek-tips.com/viewthread.cfm?qid=27369&page=1433

 

[netrusher]

Thanks Remou,

How do I utilize the code with running a query and have
the query display the correct results?