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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QUERY 5
Query ask for parameter value? 2
Maybe Update Query? 2
Crosstab Query Column Headings 2
Help with small result type 2
Combining Queries 4
2nd post - Crosstab query column headings 2
select records where first letter of name begins with an a through 3

Back
Top