Query Criteria - EXCLUDE MULTIPLE?

[Guest]

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.

 

[Rick Brandt]

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.

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

 

[Guest]

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

 

[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