Problem with "Not" criteria used in Select Query

[maindaco]

I have a set of records in a Table and I'm using a Select Query to obtain only the records not equal to "Blue 123", this is a Text field and chances are that other values exist like "Yellow 456", "Red 789" and even can exist Null data. However, when I run the query, it doesn't work perfectly. It seems that it excludes "Blue 123" and Blank fields and shows anything else. I also tried using "Not Like" in criteria without any luck. Any idea and explanation of why this happens and how to correct it? Thanks.

[Bob Fitz]

Can you show us the SQL of your query.

[maindaco]

SELECT [tbl000-TMC Details].Period, [tbl000-TMC Details].Year, [tbl000-TMC Details].Country, [tbl000-TMC Details].DocumentNo, [tbl000-TMC Details].[Amount LC], [tbl000-TMC Details].Currency, [tbl000-TMC Details].Comments, [tbl000-TMC Details].Text
FROM [tbl000-TMC Details]
WHERE ((Not ([tbl000-TMC Details].Comments)="Blue 123"));

[Bob Fitz]

I think the following WHERE clause should give the desired result. If not, can you post a copy of your db.
WHERE ((([tbl000-TMC Details].Comments)<>"Blue 123"));