How do I restrict the query to exclude items?

  • Thread starter Thread starter Guest
  • Start date Start date
exclusion operators would be

Not Like
<> (this one essentially means "not equal to")

hth
 
On Thu, 5 Jan 2006 12:08:03 -0800, "Susan"

It's considered polite to ask your question in the text area (the big
white box), not just the subject line. That gives you the opportunity
to explain your table structure and give an example of what you want
to exclude.

One WILD guess (since I don't know either of these things): try a
criterion of

NOT IN("a", "e", "i", "o", "u")

to exclude records where the field consists of a single vowel. Adapt
to your circumstances as appropriate!

John W. Vinson[MVP]
 
Thanks for the heads up - this was my first post. Tina's answer did it. Thank
you!
 
You must log in or register to reply here.

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

Exclude items in a query 2
Exclude query data 2
Query criteria - exclude data and return all records if null 3
Multiple "Not Like" not working 5
query excluding listings from table 2
Access Remove rows based on multiple fields 2
How do I create an expresion to exclude two items or NOT EQUAL to. 3
exclude weekends 2

Back
Top