How to group in Access similar texts from fields from huge data?
No unique id's, like wide range of unregistered and similar customers.
Similarities can occur anywhere within the field text but if you can please also extend it slightly to other fields which I do not need now but which could be interesting.
One customer originally called zoo can have names:
1. zoo 157895
2. 11fg zoo kkh22
3. usyr4877 24d zoo
Let say, I have 30 000 entries with 7 000 unique customers named these ways. Further they may appear similar but be distinct.
I am wondering how to group them to calculate in the next column totals for particulars, and if possible quickly further process for the sake of accuracy.