Query Criteria - EXCLUDE MULTIPLE?

T

T. Helm

I have a list of events in a table. Some are repeating events. I want to
create a query that will EXCLUDE certain events. In otherwords, when I run
the query, I want to NOT see certain events based on the ones I exclude in
the Query design.

Hope this makes sense? Can anyone give me the correct parameters for this?
Thanks.
 
R

Rick Brandt

T. Helm said:
I have a list of events in a table. Some are repeating events. I
want to create a query that will EXCLUDE certain events. In
otherwords, when I run the query, I want to NOT see certain events
based on the ones I exclude in the Query design.

Hope this makes sense? Can anyone give me the correct parameters for
this? Thanks.
Click to expand...

SELECT *
FROM TableName
WHERE SomeField Not In('SomeValue', 'SomeOtherValue', etc..)
 
S

Sheila D

In the criteria for the Events field try Not like "firstevent" and not like
"2nd event" etc
HTH, Sheila
 
M

Michel Walsh

If you want to not see repeated values, use a DISTINCT, or the more
versatile GROUP BY, which will let you do something with the associated
fields.


Hoping it may help,
Vanderghast, Access MVP
 
Top