Changing the weekly default days

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

Guest

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.
 
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
 
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.
 
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?
 
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])
 
Back
Top