I cannot build my query with the Not criteria.Can you help me ? When i write fo example for customerid <>1720 then customer 1729 does not appear indeed in the query. But when i write <>1720 Or <>35 nothing ahppens and even custoemr 1720 also appears.What is wrong with my query ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Not in
- Thread starter samotek
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question