How to set global first day of week in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to sort a sales report by week, but my week starts with Monday, not
Sunday. How can I change the global setting so that it defaults to Monday in
my reports?
 
I'm not sure you can change the default. However, both the Format and
DatePart functions let you specify the first day of the week, so you could
use either of them in the underlying query.
 

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
setting first day of the week 1
Change Definition of week 6
Putting days of week in normal weekday order 3
Start day of week 2
How to show day of week 4
check boxes for days of the week 7
How to Change start of week to Monday 1

Back
Top