Is there an easy way to group by week in Access ??

[jdowski]

Hi All,

In Excel there's a function "Weeknum" that you can use to help group data by week. Is there something, anything, please !!! in Access that can easily be use to perform the same function ????



Joe Dowski
Oxford, CT. USA

 

[CT Witter]

Take a look at the MS Knowledge Base article: 210604
http://support.microsoft.com/default.aspx?scid=kb;en-us;210604&Product=acc2000 Functions for Calculating and Displaying Date/Time Values

The one you are looking for is: The first day of the current week (assuming Sunday = day 1):
Date() - WeekDay(Date()) + 1

To set for monday it would be: Date() - WeekDay(Date()) + 2

HTH,
CT

 

[jdowski]

Ok, but how do I know by what number to subtract by to get back to Monday....or, how do I "anchor" Monday in a way where I can create a variable to get my transdate back to Monday....

If you use the weekday() function on the date you have, that will tell you which day of the week it is,and you can then subtract it to get Monday.

HTh

Peter