How do i set the first day of the week to default to Monday?

G

Guest

In Access you have the option of grouping in reports or pivot tables by
weeks, months, etc., but all of these default to Sunday as the first day of
the week. But we start our weeks on Mondays and this causes me to have to
add or subtract those hours which get added in with the wrong week. This is
very irating and limiting. As i can not set up reports grouped by weeks,
which show the correct information i need. How do i change this? I would
like to set a default for Access in it's options so that everything will be
defaulted to the right day, but even being able to find a way to change it on
any of the individual controls which are affected would be nice. Even the
Calendar control is this way. Seems like it should be a basic options. And
who got to decide that sunday is the first day of the week?
 
G

Guest

Thanks that help alot. it was driving me crazy. now if only i could get the
calendar control working right

S Panja said:
Try Datepart("ww",[DateField],2) in the query on which the report is based.

LostInAccess said:
In Access you have the option of grouping in reports or pivot tables by
weeks, months, etc., but all of these default to Sunday as the first day of
the week. But we start our weeks on Mondays and this causes me to have to
add or subtract those hours which get added in with the wrong week. This is
very irating and limiting. As i can not set up reports grouped by weeks,
which show the correct information i need. How do i change this? I would
like to set a default for Access in it's options so that everything will be
defaulted to the right day, but even being able to find a way to change it on
any of the individual controls which are affected would be nice. Even the
Calendar control is this way. Seems like it should be a basic options. And
who got to decide that sunday is the first day of the week?
Click to expand...
Click to expand...
 

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

How & Where to change the week Starting day. 3
Pivot table define Monday as first day of week 3
Finding the date of the first day of the week using "ww" to ID Wee 3
How can I set the first day of week to Monday in a pivotchart? 1
Date for 1st day of the week 1
Set firstdayofweek on report sorting and grouping 2
changing default starting day for week numbering in access 9
Calculate day of week in form & store in table 2

Top