AccessNewbie2007
Registered User.
- Local time
- Today, 09:25
- Joined
- Aug 5, 2007
- Messages
- 24
Hello all, I am having a small issue with report and I would appreciate your advices. I have the following fields that I want to sum-up by week (7 days) and not 7 calendar days.
Date - Total 1 - Total 2 - Total 3
when I am doing a sum and order by week it is taking the date as a calendar date of the week and making the summarize..
For example if the date is 01/10/2009 and I want to sum it up to 7 days, what I need as a result is a total for 01/10/2009 - 08/10/2009 but access is considering it as 01/10/2009 - 04/10/2009 as a week and start monday 05/10/2009 as a new week.
my report must summarize entries from year 2008-2009 weekly based on the initial date and not calendar days.
thanks a lot
Date - Total 1 - Total 2 - Total 3
when I am doing a sum and order by week it is taking the date as a calendar date of the week and making the summarize..
For example if the date is 01/10/2009 and I want to sum it up to 7 days, what I need as a result is a total for 01/10/2009 - 08/10/2009 but access is considering it as 01/10/2009 - 04/10/2009 as a week and start monday 05/10/2009 as a new week.
my report must summarize entries from year 2008-2009 weekly based on the initial date and not calendar days.
thanks a lot
