NOT use in a query

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

Guest

i have a table and already two queries based on it using field called LabelSiz

one query selects all the labels of size "150 x 40" and the other selects
those "75 x 20". here's the problem i can't seem to create a query (OtherSizes
that selects all those labels that aren't selected by the prvious two queries

I have attempted to use NOT & AND in the design page in the criteria sectio
but no luck. i know it must be something simple but i just can't get it
its probably just my syntax agai

Thanking you in advanc

Purny.
 
Purny

Try this....
<> "150x40" and <> "75x20"

or try

<> "150x40" or <> "75x20"

I can never remember which one to use...the 'and' or the 'or'. Try them both
and go with what works. I think it's the 'and' one... :)

Tony
 
i have a table and already two queries based on it using field called LabelSize

one query selects all the labels of size "150 x 40" and the other selects
those "75 x 20". here's the problem i can't seem to create a query (OtherSizes)
that selects all those labels that aren't selected by the prvious two queries.

I have attempted to use NOT & AND in the design page in the criteria section
but no luck. i know it must be something simple but i just can't get it.
its probably just my syntax again

Thanking you in advance

Purny.
Click to expand...

Several ways to do it:

[Size] <> "150 X 40" AND [Size] <> "75 X 20"

or

NOT ([Size] = "150 X 40" OR [Size] = "75 X 20")

or

NOT IN("150 X 40", "75 X 20")

You're quite right - using NOT in logical expressions can get your
mind twisted up like pretzel. It's very simple if you can think like
a computer, but only Data and Spock seem to really have the knack
naturally!
 
Thank you very much John (sorry Lurch an error message comes u
when try to read your post but thanks anyway). these newsgroups are grea

Cheer

Purny
 
Back
Top