Hello all. I have a Timesheet program where users fill in various 

information, one of the fields being the current date. It is entered by 

default for them as the current date. I wish to leave this entry method.



I wish to pull info on all user's by each week of the year for a managerI 

need to create a manager's report that can pull all the user info by 'week 

of the year'. Thus I would do a drop down list or hyperlinks for week 1-

52, where they would click and all the info would be pulled for that week 

only.



I have had problems using 'datediff' and believe someone out there may 

have a better idea. Can anyone advise a suitable solution, or perhaps 

examples from something they are already using?



Thanks in advance!

Scott Taylor