If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Not statement not working
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200911/1 |
#2
|
|||
|
|||
Not statement not working
[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 "jerry001 via AccessMonster.com" u48786@uwe wrote in message news:9fb0fee3f2273@uwe... 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200911/1 |
#3
|
|||
|
|||
Not statement not working
thank you
it worked perfectly -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200911/1 |
Thread Tools | |
Display Modes | |
|
|