View Full Version : Unmatched query problem


arage
11-01-2001, 06:38 AM
Unmatched query problem
I’m using the unmatched query wizard to help find different values between a table and a query. Nothing shows up in my results even though I can easily point to at least 3 records where there’s a non match. The value being matched up against in the query is essentially an expression while in the table it is a field would that cause a problem?

aftershokk
11-01-2001, 06:50 AM
try the query backwards

arage
11-01-2001, 06:51 AM
i have no idea what that means

aftershokk
11-01-2001, 06:53 AM
are you using the wizard - if yes, try it vice versa

lscheer
11-01-2001, 01:50 PM
...meaning, that if you tried to find which records are in tblX, and not in tblY, try running the query the other way around; find which records are in tblY and not in tblX.