Hi,
I've looked at VLOOKUP and Pivot Tables but so far no luck.  I have a long list of dates ranging from 1/1/11 through 12/31/14.  I want to change the dates into date ranges.  The ranges are as follow:  Before 1/1/12; 1/1/12-12/31/12; 1/1/13-6/30/13; 7/1/13-12/31/13; 1/1/14-6/30/14; 7/1/14-12/31/14.  So for example, I would want '2/14/14' to read as '1/1/12-6/30/14'.  Thank you

---

Reply from Alex Hedley:

You could add another Field to your Query that sees where it is in your range and assign a data or number. Then you could group by that value in your report, make it a header and add your range there.