Roll-Up or Grouping column name

[Sed]

Hi,
Can someone please help? I have multiple company name in my data that are the same but spelled differently. All I want is to group or roll them up together given one name, or another of my choice. For example…
“ADVANCE CO”
“ADVANCE FA”
“ADVANCED B”
“ADVANCED C”
“ADVANCED I”
“ADVANCED P”

Are all the same company. I want to just call it ““ADVANCE COMPANY”

Or
“AG CHEM“
“AG CHEM EU“ want to roll it up to “AG CHEM“

I’ve been doing the find and replace, but every time I upload new data, the name appears again. I don’t to have to do this every time I upload new data.

Is there away to automate this in Access and give it a “new” name column?

Thanks a bunch.

 

[John Big Booty]

Have a look at the various String functions particularly Instr().

I suspect in the end though that you will not be able to fully automate this process and some level of user intervention will be required at some point in the process.