Changing the weekly default days

S

SharonInGa

The current default for a weekly report on Access is Sunday through Saturday
(I think). How do I change the weekly reports to pull up Monday through
Sunday.
 
J

John Spencer

Could you show us the "defaults" you are now using?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

It may be something as simple as adding 1 to the dates you are already
calculating

DateAdd("d",1-WeekDay(Date()),Date()) +1 To get Monday vice Sunday
DateAdd("d",1-WeekDay(Date()),Date())+7 To Get Sunday vice Saturday
 
D

Duane Hookom

Sharon,
I see you have asked similar date type questions in two other recent
threads. A couple of these have responses with questions back to you. You
haven't responded in any of these threads. Please respond back to John if he
is hitting the mark on this or you need additional information.
 
S

SharonInGa

Thanks Duane, I'll be more careful where I put threads Now heres the
question regarding defining a week for reports.

You can set the Grouping and Sorting option in a report to group on various
options including: Each Value, Year, Quarter, Week .......

I want to run a Weekly report that begins on Thursday through Wednesday.
How do I set the Week to those days? Can I define the "week" at the
grouping option, in the query or somewhere else?
 
D

Duane Hookom

You can add or subtract a number of days to your date field so the grouping
becomes in synch with your needs. For instance to group by weeks beginning
with Monday on a date field, use:
=DateAdd("d",-1,[DateFieldName])
 
Top