Thanks for the example Norbert. I will check this out to see if I can make it work for my situation. I will let you know how it goes. Thanks again!
I tried your example Norbert...however I would need the city to also show up by itself and not part of the calculation. So for example, I would need the following:
Abilene Acura Blue
Abilene Honda Green
and perhaps many others.