Is there an easier way of writing this in a query

[bearcub]

I have a number of members that I need to exclude from a particular query. What I did was to have a string of Not Like Statements in the criteria section of the query to exclude these members from the query. Is there another way to do this in access?

This is the what I presently have and it works. I just wonder if there is another way of doing this:

Not Like "Elana Davidson" And Not Like "Dean E. Vogel" And Not Like "John C. Stocks" And Not Like "Joe Nuñez" And Not Like "Becky Pringle" And Not Like "Dr. Theresa Montaño" And Not Like "lily*" And Not Like "Princess R. Moss" And Not Like "Eric C. Heins" And Not Like "Mike Myslinski"

Thank you for your help,

Michael

 

[james_lankford]

where 
(
  (
    not in ( 
      'Elana Davidson', 
      'Dean E. Vogel', 
      'John C. Stocks', 
      'Joe Nuñez', 
      'Becky Pringle', 
      'Dr. Theresa Montaño', 
       'Princess R. Moss', 
      'Eric C. Heins', 
      'Mike Myslinski' 
    ) 
  )
  and 
  (
    not like 'lily*'
  )
)

 

[bearcub]

Thank you. Is this what you've written here in SQL or in the design view of the query. If this in in SQL, how would I write this in the actual query itself.

Michael

 

[Joe4]

For queries, in addition to Design View, Access has has SQL View. As long as what you are trying to do can be represented in Design View, you can bounce back and forth between these two views (certain types of queries, like Union queries, can only be seen in SQL View). So you could add this criteria in either View.