I have a crosstab query where I can compile the totals per day that I want. What I need to do is then group these days into weeks by the following Sunday for a week ending total. How can I link each day for its corresponding week ending date. I attatched an image if it helps.
Off the top of my head, I'd try grouping the dates together in a sub query. There should be a Week function to help with the grouping, then have crosstab query use those weeks.
