RossWindows
Que?
- Local time
- Today, 04:00
- Joined
- Feb 25, 2008
- Messages
- 410
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.
Here's a sample of the end result that I need. I can also post the sql I am currently using if needed.