Hi everyone!

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!

Cody A

Use a Find Unmatched query for this. Click Queries in the Objects list, then New in the short toolbar right above the Objects list. Double-click Find Unmatched Query Wizard. Follow the steps.

You want to find the area codes in the "main" table that do not have a matching record in the area code table.

thank you for this

You're welcome. I am glad I was able to help.