G
T
tina
exclusion operators would be
Not Like
<> (this one essentially means "not equal to")
hth
Not Like
<> (this one essentially means "not equal to")
hth
J
John Vinson
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]
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]
G
Guest
Thank you - that did it!
tina said:
G
Guest
Thanks for the heads up - this was my first post. Tina's answer did it. Thank
you!
you!
T
tina
you're welcome 
Susan said: