Double Filter?

[charmac2013]

I have a page that displays data from a mysql database and I can successfully use one filter however I need to filter the recordset by two different fields. Is this possible in the advanced settings? Any help is awesome. Thanks a lot.

[MurraySummers]

SELECT * FROM table WHERE field1 = 'whatever' AND field2 = 'whatever2'

Sure - you can do that in the advanced section.  Just add another filter to the WHERE.

[SyberKnight]

***ANSWERED***

...as far as i'm concerned.

THANK YOU to Murray for your clear, concise, & perfect answer. i've been searching & reading for hours on how to do this, and ALL the other solutions so far were so convoluted and hard to understand. but yours was simple and exactly what i needed.