Including prev week numbers in current week query

[RossWindows]

I'm building a crosstab query to show different totals and counts for monitoring scores. The query that the crosstab is based on has a date parameter where the user enters a start and end date (always a 7 day range) but in the results, I also need to see the average score for the previous week. How would I accomplish this?

Here's a sample of the end result that I need. I can also post the sql I am currently using if needed.

 

[wiklendt]

i suggest you build a report based on the cross tab, and then make a second cross tab which draws out the previous week's data - that way you canb have both on the report at the same time (i.e., view them at the same time)