Access 2003 Query - what does this <> mean?

[Guest]

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

 

[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".

 

[Sylvain Lafontaine]

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

 

[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

<> "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" & "*"

 

[Guest]

Thank you all very much!!!

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

Brenda