Hi, I am a relatively new user of Access and this forum. My objective is fairly simple in that I wish to compare two lists of words (Text) and generate two possible outcome. If field one is WORD and contains say 100 words and Field Two is a smaller list of say 50 words in which 45 of the 50 are in field one and 5 words are not. I would like to see the 65 words remaining in list one and the 5 new words not in list one going to Field 3 which is empty at the beginning. Attempted to attach excel file, attached .pdf in place. Looking forward to any help of suggestions, thank you for taking the time to read.