I haven't worked with cross tab queries, but I can get what I think you want from a standard query. If I'm reading your post correctly this query should give you the starting point:
Select Employee, Format([Date],"ww") AS Week,
sum(Value) As ValueSum From qryRollingAverage1
Group by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.