jmdomini
Premium
join:2000-05-04
Aurora, IL
 ·Sprint Mobile Broa..
| [Access] Not Equals To Query
I have to do an audit of our phone system and it's way too many records in multiple databases to compare by hand. I put together a small Access database to play with and have been trying to figure out how to do a not equal query all day with no luck. Basically in my sample there's the following...
Extensions - normal stations
Agents - agent ID's
Report- data from the chargeback system that includes both agents and normal stations.
So I need to query to look for entries that are in the "Report" database that aren't in the "Agents" database while excluding the records in the "Extensions" database.
So in my little sample the query should return "1117 Jim".
Help!! |
|
Cudni
La Merma - Ciudad Fronteriza
Premium,MVM
join:2003-12-20
Someshire
 ·BTOpenworld
| One approach
Using Query wizard create Find Unmatched Query and connect Report with Extensions. Save the query. Now repeat the process but connect just saved query with Agents database and reap the results. It works 
Cudni
--
"Mercifully, he hit him with the soft end of the pistol."
Help yourself so God can help you.
Microsoft MVP, 2006 - 2008 |
|
jmdomini
Premium
join:2000-05-04
Aurora, IL
·Sprint Mobile Broa..
| Well I feel really stupid. I realized the reason my queries kept coming back blank no matter what I did. It helps if the data you are trying to query actually exists! DUH!!
Apparently when got the charge back dump off the mainframe I did something wrong and I only have a partial data set. At least I know what I need to do now! |
|
