criteria help

V

vicky

I have a query with occurence date field and nature field. I need to exclude
5 different words in one field (the nature field). is there a way to do that?
Help greatly appreicated
 
J

John Vinson

I have a query with occurence date field and nature field. I need to exclude
5 different words in one field (the nature field). is there a way to do that?
Help greatly appreicated
Click to expand...

NOT IN ("this", "that", "theother")

on the Criteria line should do the trick for you.

John W. Vinson[MVP]
 
Top