field comparison and contrast

[merlin666]

Is there a way to take two fields and compare them and list the differences. Ie. Compare field one "This is a good day" to field two "Tomorrow is better" and have a report stating what letters are in both fields, what letters are only in field 1 and which are only in field 2. Field could also contain numbers if that makes a difference

Better description:
I am in charge of changing an outdoor marquee(magnetic letters). We have a database that allows me to plan for what will be on the marquee over the coming months, but the report doesn't give any letter changes. I usually have to go through the letters on paper and cross off what I don't need to take out with me, or I could take out all the letters. I found a program called marquee manager that does this but on a change by change basis. I am looking to add similar functionality to the report so if I'm not there someone can quickly look and see what letters need to be taken out for the change.

 

[gemma-the-husky]

i would have a 2-d array of size 26 to store counts for string a and b

then do a for next loop to compare the totals for each letter

 

[merlin666]

How would I do that. I'm somewhat new to both access and VBA.