I am trying to search a field for a letter that does not equal Y. I have tried various methods such as /=Y, and Not equal to Y, etc. But nothing works. How is it properly inputed, to find a letter that is not equal to Y but does have a letter in the field, in otherwords it is not empty. Thanks.

<> y

Thank you NAGYL for the very fast response. I just went to the bathroom and when I came back there was the answer. Now that's what I call fast. Say, is there a list of those searching formats somewhere in the HELP files for Access. I looked but could not find one, but I know there must be one. Thanks.

Oops. That doesn't appear to work. I am writing it in the Find Box like this you said <> Y, but nothing is coming up. I have tried it with other fields as well and it does not work. What am I doing wrong? Thanks.

Excuse me again. It does work when using a filter but not with Find and Replace. It seems odd to me that it would work with one but not the other. Anyhow, thanks!

You've confused me (not hard to do). Maybe some more info on your problem would help.
There is some info on the operators such as Like, <>, and Not in the visual basic help if you look in the contents: Language Reference: Indexes/Lists: Operators Keyword Summary.

Type this in the microsoft access help:

"About using wildcard characters to search for partial or matching values"

Your will find all of them!

Sohaila