One note of interest: When I run the database tuning advisor, it suggests an index on a table we do not control. We will be asking the company we purchased...

Thank you! I'm just getting back to this after being placed on another project for the last little bit. I'll look into the indices suggestion on the table.

G Squared -...

I appreciate the reply and trust me when I say I know it's an incredible amount of information. It's not at all simple to work out. LOL

But as I came...

I didn't receive any help or nibbles of any kind, however, as I've been looking over this I can see my "feeling" that it was grouping before it should seemed...

Gail - so far the query you provided checks out. I'm waiting back to hear from the other department to see if the results are what they would expect to...

Yes, we took several fields from one system that were not being used so we could link tables from a diff system that ID's vehicles in a totally diff way.

VehicleColor...

Thanks. I will test this and if magic doesn't occur immediately I will post table def and sample data. I appreciate the help.