By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,834 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Using Not in Access query

P: 1
I ran a query with a criteria of several years
exp: 1962 or 1967 or 1972 or 1977 or 1982 or 1987
that pulled fine, but now I want a query that will pull remaining years but not the years above. Since I do not all years involved I want to say NOT 1962 not 1967, etc.
Please tell me how to set this up, thanks
May 20 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
I ran a query with a criteria of several years
exp: 1962 or 1967 or 1972 or 1977 or 1982 or 1987
that pulled fine, but now I want a query that will pull remaining years but not the years above. Since I do not all years involved I want to say NOT 1962 not 1967, etc.
Please tell me how to set this up, thanks
use not like 1962 and not like 1977
or
not = 1977 and not = 1962
or
not in('1962,'1982) '
May 20 '07 #2

ADezii
Expert 5K+
P: 8,619
I ran a query with a criteria of several years
exp: 1962 or 1967 or 1972 or 1977 or 1982 or 1987
that pulled fine, but now I want a query that will pull remaining years but not the years above. Since I do not all years involved I want to say NOT 1962 not 1967, etc.
Please tell me how to set this up, thanks
Expand|Select|Wrap|Line Numbers
  1. Not In ("1962","1967","1972","1977","1982","1987")
May 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.