I have a Sales table with dates (Sale_Date).
I also have a table of Qtrs (1st,2nd,3rd,4th) - Business Qtrs
The table of Qtrs looks something like this
1/1/2015 3/31/2015 1ST
4/1/2015 6/30/2015 2ND
How can I group and sum my Sales data by QTR? Sales date must fall in the Qtr date range.