Results 1 to 3 of 3
Thread: Return date range of information
Jan 5, 2010, 10:08 #1
Return date range of information
I'm working with charts in Flash and need to create an xml file that will store the data for Flash to access. I was wondering if there was an easy way to do this:
I want 1 query that will count totals from one date to another. So something like this:
6/09 - 125
6/10 - 55
6/11 - 0
6/12 - 15
6/13 - 581
6/14 - 33
I know I could just do 7 queries but if the date range is a lot higher I could end up doing a ton of queries.
So I was just wondering if anyone had a solution to returning that information in 1 query.