Access 2003 Query - what does this <> mean?

B

B. Levien

In a pre-existing query, under the criteria, I see

<> "word processor"

What does <> mean, exactly? I have looked through all the materials I have,
and cannot find what these brackets are indicitive of (my best guess is "pick
the fields that have "word processor" in it only?).

Thank you very much.

Brenda
 
J

John Spencer

<> is the way to say NOT Equal.

So, that should be getting all records where the field is not equal to "word
processor".
 
S

Sylvain Lafontaine

This is the NOT EQUAL operator (or the inverse of the EQUAL = operator).
 
F

fredg

In a pre-existing query, under the criteria, I see

<> "word processor"

What does <> mean, exactly? I have looked through all the materials I have,
and cannot find what these brackets are indicitive of (my best guess is "pick
the fields that have "word processor" in it only?).

Thank you very much.

Brenda
Click to expand...

<> "word processor" means NOT "word processor", so only records that
do NOT EQUAL that EXACT phrase would be returned.

To return records that DO NOT have "word processor" anywhere in the
field, i.e. "I have a Wang word processor at work." you would use:
Not Like "*" & "word processor" & "*"
 
B

B. Levien

Thank you all very much!!!

It means the exact opposite of what I thought - LOL.

Brenda
 
Top