Generating year range in report
I need to generate a report that would give me year ranges instead of just a series of numbers. For simplified purposes, let's assume my table just consists of ID, a first name, and a year.. So maybe..
1 John 1980
2 John 1981
3 John 1982
4 John 1985
5 Melissa 1980
6 Steve 1980
And I need... John: 1980-1982, 1985
Any ideas? I was thinking about running some kind of VBA maintenance to update an undisplayed extra text field on the table to maintain the range, then doing group bys to display the information. But I was hoping that there was a better way to go about it. I was planning to store the year as an integer value, since month and day will never come into play.