UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Filtering for Invalid Area Code in a Query    
 
   
caustexx
post Jan 31 2006, 10:26 AM
Post #1

New Member
Posts: 8
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
Go to the top of the page
 
+
fkegley
post Jan 31 2006, 10:48 AM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi
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.
Go to the top of the page
 
+
caustexx
post Jan 31 2006, 12:03 PM
Post #3

New Member
Posts: 8
thank you for this
Go to the top of the page
 
+
fkegley
post Jan 31 2006, 01:46 PM
Post #4

UtterAccess VIP
Posts: 23,583
From: Mississippi
You're welcome. I am glad I was able to help.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 09:58 AM