Multiple filters for 1 column

[Savale]

I'm trying to sort out a couple of things in one column, but every time I do it, nothing happens. How do I sort out more than 1 thing from a column?

 

[jebry]

Hi!

If I am understanding you correctly, you need to use the Or operator:

[DataColumn] = "FirstData" Or [DataColumn] = "SecondData" etc.

hth
Jeff Bridgham

 

[Savale]

I've tried that. It does absolutely nothing for filtering out the 2 things I need to be out. If I do it one or the other, it works fine, but if I try to sort both out, nothing happens...

Oh yeah.. this is being done in the query design view

Criteria: Not Like "RST*"
OR Not Like "SUS*"

This will do nothing.. If I do not add the OR, it will sort out anything with "RST", but I need both values removed.

 

[tempclerk]

You need
Not Like "RST*" AND Not Like "SUS*"

 

[jebry]

Hi!

If you are using the Not operator, change the Or logic to And logic. That should give you what you want!

hth
Jeff Bridgham

 

[Savale]

Thanks so much... I'm kinda used to C++ and Java... I was trying to use && for and, but that worked out just fine.