Access 2003 Query - what does this <> mean?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
<> is the way to say NOT Equal.

So, that should be getting all records where the field is not equal to "word
processor".
 
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" & "*"
 
Thank you all very much!!!

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

Brenda
 
Back
Top