Grouping Years for Parts table

[Aurillius]

Hi there,
I just received a huge kickout table from our data company. There is over 10 thousand records. In order to compare this to our records, I have to group the parts by everything except the year, they need to be collected together and then displayed as a range on the report.
Here is an example of the data, the left side is the field name:
YEAR = 1999
MAKE = GMC
MODEL = SONOMA
APP = AXLE REPAIR
POS. = FRONT
LOC. = OUTER
PART# = 1234
What I need is a report/query that will group this data as such:
99-92 GMC SONOMA AXLE REPAIR FRONT....etc.....

Thanks,
Aurillius