SQL query with AND or OR

Hi,

I am trying to get a recordset that samples multiple columns of my Access database for filtering, rather than just one.  I looked at a few .asp websites and they say the query would be written like this:

SELECT SystemName, SystemCategory, Branch, Manufacturer

FROM UnmmannedAircraftSystems

WHERE Branch LIKE %MMColParam%

AND PerfSensorPayloads LIKE %MMColParam2%

ORDER BY SystemName ASC

but it never works.  The page fails on the server.  And I know this type of query works through straight .asp coding, but somehow the way Dreamweaver sets up the variables is killing it.

Anybody have an ideas?

MW