Create queries based on workweek..

[shieriel]

I have a query that creates average data per day and also summarized on a per month basis. But i am now requiring to create a summary where instead of monthly summary, the database will show per workweek.
For example: Workweek1 is 1st week of january, that will show an average; workweek2 is 2nd week of january, and so on...
I cannot get the right way to do this... please help..

 

[jdraw]

There is a function here that might be helpful. At least you can look at it and decide

http://www.utteraccess.com/forum/fNetWorkdays-fAddWorkDay-t1349593.html

 

[shieriel]

Ok let me see that. Thanks....

 

[shieriel]

I am sorry to say that it's hard for me to understand the codes. I am not very good on codes since i only learned access through self research and study. Can you please give me a sample database that uses workweek summary? Many thanks in advance.