I have a customer database in which a number of companies have modified their company names. When I look at my sales performance query I have to manually total the numbers for these different "name changes" for comparison purposes.

Is it possible to make a query in which I can total the "name changes" as one company.

eg. Joe Bloggs, Joe Bloggs & Co, Joe Bloggs & Co Ltd, J Bloggs Ltd. I would...