Using Not in Access query

[rivemel]

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

[JConsulting]

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) '

[ADezii]

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

Not In ("1962","1967","1972","1977","1982","1987")