Grouping by week

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a scheduling query that groups by week. However, I
would like to keep weekends together. Is there a way to
get the query to use Monday as the start of week?
 
In many of the date functions, there is a parameter to specify the starting
DOW. See the help file for the specific functions that you are using.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Sorry, but I should have mentioned that I'm using Access
2000 and using the built-in Report grouping feature. In
the help file it states that the sort order can either be
US or international, but I don't know of any country that
specifies Monday as the start of the week. I guess I
should be defining an expression in the query and then
grouping the report by the expression, but I was hoping
there would be a built in way to specify the week start
date.
 
Back
Top