QUERY FORMULA

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

Guest

I want my query to include everything but MDN and M with two numbers like M10.
I tried<> M** and<> M??, and <>M##. None of them worked.
Thanks for any help
ed
 
I want my query to include everything but MDN and M with two numbers like M10.
I tried<> M** and<> M??, and <>M##. None of them worked.
Thanks for any help
ed
Click to expand...

The <> (unequal) operator does not recognize wildcards - only the LIKE
operator does. Try

<> "MDN" AND NOT LIKE "M##"

John W. Vinson[MVP]
 
Back
Top