triplell89
Registered User.
- Local time
- Today, 07:57
- Joined
- May 21, 2009
- Messages
- 21
I have a list of accounts that I want to compare to itself and find similiar names.
For example, you have a list of words:
Angle
Angel
Orange
Banana
Bananna
Banana1
Blue
I want to produce a query that would compare this list to itself, and Give an ouput like so if the first three letters match, then it will show it in the second column.
Angle-Angle
Angle-Angel
Angel-Angle
Angel-Angel
Orange-Orange
Banana-Banana
Banana-Bananna
Banana-Banana1
.
.
.
Blue-Blue
I would then like it to on display where column 1 <> column 2
and then keep a count on how many times something appears in column 1 in a third column.
I was trying to do this in access, but I'm having no luck. I know I could write a macro in excel to do it, but I'm sure it's possible in access.
Thanks for your help.
For example, you have a list of words:
Angle
Angel
Orange
Banana
Bananna
Banana1
Blue
I want to produce a query that would compare this list to itself, and Give an ouput like so if the first three letters match, then it will show it in the second column.
Angle-Angle
Angle-Angel
Angel-Angle
Angel-Angel
Orange-Orange
Banana-Banana
Banana-Bananna
Banana-Banana1
.
.
.
Blue-Blue
I would then like it to on display where column 1 <> column 2
and then keep a count on how many times something appears in column 1 in a third column.
I was trying to do this in access, but I'm having no luck. I know I could write a macro in excel to do it, but I'm sure it's possible in access.
Thanks for your help.