I have a small problem. I have a list of phone numbers, call them [data set]![area code], and i need to get all #'s with invalid area codes.
I have a table with all valid area codes, call them [Valid Area code list]![Area Code], and my data set.
typing "Not Like [Valid Area code list]![Area Code]" into my [data set]![area code] criteria field produces multiple rows for each data set, like it is checking every area code on [Valid Area code list] and reporting back when it is not like each row.
Any help is appreciated!