I have a database filled with automotive vehicle descriptions and associated parts for those vehicles.  I am setting my report up in a catalog type of lookup where the Make > Model > Submodels > then year and detail are listed, similar to this:

Cadillac
     Escalade

          All Submodels

                           1999       5.3L       Part #123

                           2000       5.3L       Part #123

                           2001       5.3L       Part #123

                           2002       5.3L       Part #123

                           ...

 

What I would like to do is use a tool or create a formula that will combine the years of otherwise similar records, such as:

 

Cadillac

     Escalade

          All Submodels

                          1999-2002       5.3L       Part #123

 

Does anyone know of a simple way to do this?  It would reduce the size of my report by approximately 70-80%...  Thanks for any help/advice....

 

 

I probably failed to mention that there are 21,000 records and hundreds of different groupsets... was looking for a way to hopefully automate the process.  Was thinking something like "if makes, model,submodels, engine sizes,part numbers & descriptons are all equal, then print lowest year &"-"& highest year, provided years are consecutive"

 

That was a long if then.... :)

 

I understand it may not be possible, but thought I would explain it a little better.

 

I'll take a look, and thanks again for taking the time to help a newbie...