Data group by week

[hoachen]

Table 1Can the below request done by a query or it will be easy on the report?

DatePart("ww",[Date Order])
This datepart() did not separate the year.
Since every year the start date will be different 2010 week 1 start from 1/4/2010 to 1/10/2010 and 2011 week 1 start with 1/3/2011 and 1/9/2011.
This table one will continue each year 2010, 2011, 2012 data.
I tried to add a column by doinga format([Date Order], "YYYY") then when I do the crosstab. I concatenate the year and Customer Type so it will become I 2010 or I 2011

[tdecker81]

I know you marked this as solved. Post your solution for others if you would.

[hoachen]

I know you marked this as solved. Post your solution for others if you would.

I found it at this site
http://www.access-programmers.co.uk/...p/t-78904.html