Reports: Group with date by week - Can I change start of week to M

  • Thread starter Thread starter Luc Barrette
  • Start date Start date
L

Luc Barrette

Hello,

Making a report in Access 2007 and I am grouping the data by week. Access
starts the week on a Sunday. Can i change it to Sunday for this Report?

Thanks!
 
Hello,

Making a report in Access 2007 and I am grouping the data by week. Access
starts the week on a Sunday. Can i change it to Sunday for this Report?

Thanks!
Click to expand...

What function are you using to group by the week?
Look up the arguments used in that function.
You will find an argument to start the week at any other day.
 
Thank you.

In 2007, there is an a new area at the bottom of the report design page to
add grouping and sorts. I cannot locate the control that you are talking
about. BTW, I meant Monday for the new start of the week.

THanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Report-How ot change start of week 2 Monday 4 weekly g 4
How to set global first day of week in Access 2003? 1
How to Change start of week to Monday 1
Weekly Date Calculation 9
Week of the Year, Starting with the 1st Sunday (?) 2
Main form- subform for -logging hours worked for day/week 2
Week Ending Dates 2
main form based on table with no date field-need to tie-Sun dt w/s 2

Back
Top