I have several hundreds of thousands of transactions in a month and i'm trying to aggregrate the results by vendor. Unfortunately, the vendor name has not been entered in the same for every instance where it should have been. For example, Transation 1 is listed with Vendor "Fairmont Hotel" and Transation 2 is listed with Vendor "The Fairmont Hotel". Since both are the same property, I would like to be able to pull all data relating to Fairmont property. While I know I can manually group these fields, it would be an exteremely cumbersome process with the amounts of data I am analyzing. Is there a workaround in Access or Excel that I could try? Thanks!

You could use;
Like "*Fairmont*"
As a query criteria to select all records that contain the word Fairmont. This however really isn't going to solve you problem in the long run.

What you need to do is force you users to select vendors from a Combo Box, in this way you can avoid this sort of issue in the future.