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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 02/27/05


Date: Sun, 27 Feb 2005 13:13:58 -0500

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.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Qman" <Qman@discussions.microsoft.com> wrote in message 
news:B0934256-1D99-4977-8530-E6C393D8CC88@microsoft.com...
>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?