ASP: multiple criteria recordset filter

Nope.  Still got the same thing when trying to filter with the string.  

I don't see how I can filter twice - surely the second filter starts from scratch, so if 10 records have a town of 'Leicester' and 10 records have a Country of 'UK', but only 5 of the 'Leicester' towns are set to a country of 'UK', if I do a filter on 'Town=Leicester' followed by a filter for 'Country=UK' then I'm going to get 10 records, not the 5 that I want, aren't I?

The filters should compound each other. To flush the filter you must set it equal to "".

They don't compound each other.  I have two fields that I know only 8 records have both set to true on. 10 records have the first, 13 records have the second, when I do a recordset.filter="1stItem=true" and do a recordcount I get 10 items returned.  Immediately after that line I do:
recordset.filter="2ndItem=true" and I get a recordcount of 13 returned, not the 8 I would want.
Here's the code:

rstemp.filter="Item1=true"
regioncnt2=rstemp.recordcount
response.write regioncnt2
rstemp.filter="Item2=true"
regioncnt2=rstemp.recordcount
response.write regioncnt2

This returns "1013" not the "108" I want!

They don't compound each other.  I have two fields that I know only 8 records have both set to true on. 10 records have the first, 13 records have the second, when I do a recordset.filter="1stItem=true" and do a recordcount I get 10 items returned.  Immediately after that line I do:
recordset.filter="2ndItem=true" and I get a recordcount of 13 returned, not the 8 I would want.
Here's the code:

rstemp.filter="Item1=true"
regioncnt2=rstemp.recordcount
response.write regioncnt2
rstemp.filter="Item2=true"
regioncnt2=rstemp.recordcount
response.write regioncnt2

This returns "1013" not the "108" I want!

The way you've tried should work, I think. So should the multiple filter. Do something goofy like bounce the server or add one more " to the end of your original string.

Jok, do you mean add another " to the end of the multiple field filter in the first question?  I tried it - didn't work. It's the 'OR' that's upsetting the apple cart, I can have as many 'AND's as I like and it's fine, just hates the 'OR' which is a pain.

I can't understand why the consecutive filters isn't working then - is the proper behaviour for the system to compound the filters until I reset the string?  I've always had consecutive filters do this and just assumed it was what happened.

try
recordset.filter="(town='leicester' OR town='london') AND (county='Leicestershire' AND country='UK')"

see also
http://msdn.microsoft.com/library/sdkdoc/sna/thorref4_8kbm.htm

see also
http://msdn.microsoft.com/library/sdkdoc/sna/thorref4_8kbm.htm

Thanks JOK,

The last link you posted has answered the question.  Here's a portion of the page:
---------------------
One restriction on these combinations is that OR clauses can only be used at the highest (major) level of the logical operation.

Examples of acceptable Criteria meeting these conditions are:

recordset.Filter = "(Title='Manager' AND Salary>30000) OR (Title='Administrator' AND Salary>50000)"
------------------------------

This means I can only have the 'or' acting as an operator between the 'and' clauses, I can't 'and' an 'or'...damn!

Post your last comment as an answer and the points are yours.