How to do != "xxx" in access 97??

[marco_pb via AccessMonster.com]

thx in advance for all of you..
I'm kinda noob in using access SQL, I don't know how to do SELECT a FROM b
WHERE c != "xxx";

can somebody help me pleaseee...

thank you very much...

 

[Tom Lake]

thx in advance for all of you..
I'm kinda noob in using access SQL, I don't know how to do SELECT a FROM b
WHERE c != "xxx";

Use <> instead of !=

Tom Lake

 

[marco_pb via AccessMonster.com]

sorry to have you bothered... I have got the answer..
I add: Not "xxx" into the criteria box in design view.

thank you..