when grouping data as weeks, show title as first day of the week! 1

[jefferyzhong]

I have a question need help,
I can group the data as weeks, but the title shows as "number", I want it shows like the first day of the week.

for example: today is 05/24, yesterday is 05/23, the first day of this week is Sunday, 05/22. so when I group by week, today and yesterday will be grouped together and shows as 05/22!

you help will be highly appreciated!

Jeffery

 

[PHV]

SELECT [Date Field]-DatePart("w",[Date Field])+1 AS [Week]
...
GROUP BY [Date Field]-DatePart("w",[Date Field])+1;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jefferyzhong]

thanks a lot!

Jeffery