Not statement not working

  • Thread starter jerry001 via AccessMonster.com
  • Start date
J

jerry001 via AccessMonster.com

I went through the forum but couldn't find an answer to that

ok

so I need a query that gives all records that don't have a set of values in a
field.

i.e. lets say Field "TOP" should not be 10 or 20 or 30 or 40 .....

I tried a multiple or Not query but it does not work.

Can someone spell it out for me?

thanx
 
V

vanderghast

[top] NOT IN(10, 20, 30, 40)

or, if you mean multiple of 10

0 <> [top] MOD 10




Note that TOP is a reserved word (SELECT TOP 100 ... ), so it is highly
preferable to use [ ] around it to indicate that you mean the field of that
name.



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

Top