Sum of Groups within Date Range 1

[BiggerBrother]

I have the standard orders table, with the amount of an order, the order id, the customer id, and the date. What I now need is the ability to group the order totals by quarter. So give customer id, I need to be able to display how much they spent between each quarter.

Is this possible without running the same sql for each quarter?

Many thanks

BB

 

[r937]

starting when? until when? or, how many quarters?

do you have an integers table?

see Showing how many page hits for past 40 days -- your solution will be very similar

r937.com | rudy.ca

 

[BiggerBrother]

Perfect. Thanks r937

Have a star for your efforts.

BB