Grouping by week

[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?

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Guest]

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.