Code for Not equal to

[Erictsang]

Dear all

I want to set a query requirement as "Not equal to "Sugar"as on my list

Thanks

[Bob Fitz]

Maybe:

<> "Sugar"

[Erictsang]

Strange, i try <>" 自理 " but this is not working

it returns with no values

[Bob Fitz]

Strange, i try <>" 自理 " but this is not working
it returns with no values

What are the characters you have between the quotes.

Please show us your SQL statement

[Erictsang]

Here is the quote

SELECT Registration.ID, Registration.Appl, Registration.Gender, Registration.C_FULLNAME, Registration.FULLNAME, Hotel.HOTELNAME, Registration.ARR_TRF, Registration.Arr_Date, Registration.Arr_Flight, Registration.Arr_Time, Registration.Departure, Registration.Dept_Date, Registration.Dept_Flight, Registration.Dept_Time, Registration.[Pick up]
FROM Hotel INNER JOIN Registration ON Hotel.ID = Registration.ID
WHERE (((Registration.ARR_TRF)<>"自理"));

[Micron]

Are you trying to use characters you see in a table field that has been encrypted? You are copying these characters in order to be able to use them?

[Erictsang]

"自理" this is what on the data in the field

[Erictsang]

when i put = "自理", all retrieve out

Not i want all data except "自理"

Eric

[aytee111]

Try (in SQL view)
NOT ( fieldname = "自理" )

[Micron]

In post 3 you include a space " 自理 ". In your sql, you do not, but I don't think that's the problem if you've got the correct record field value in post 7?
<>"自理" works for me when a test field contains 自理 and the field is text. Perhaps you have some sort of mask involved, though a password type field mask can only show *'s AFAIK. Or is this a number field? You might have to post a zipped copy of your db so we can investigate better.