Oh OK. I understand why my query didn't work.

Thanks for suggesting crosstab ..I haven't used this much before.

If I want print all CompanyPrevName instead of just 2, how can I generalize the query?

Thanks