NOT IN (SQL) or Find Unmatched (+ other stuff)

F

Farkyss

Sorry, yes, was a typo in copying - 999789 in that line - double checked it
by running it with such
 
V

vanderghast

Can you try the same query in MS SQL Server (whatever edition you have, some
are free)? If so, and if you get the same result, then all would point out
that the problem is with the data.

Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL "NOT IN" doesn't function as expected (refresh) 14
not in criteria fails 2
Making a Delete Qiuery from an unmatched Query 6
UnMatched Query 3
Making an Append Query from an unmatched Query 1
Unmatched query not working 4
After Unmatched Query Runs, Getting the Difference from Totals 3
can't find the right query 0

Top