Hot do you search for Not = to

[chablups]

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.

 

[naygl]

<> y

 

[chablups]

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.

 

[chablups]

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.

 

[chablups]

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!

 

[naygl]

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.

 

[Sohaila Taravati]

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