Advanced search within an advanced search
How do you do an advanced search inside an advanced search result set? For example, if I was to ask for all client records where the city is not blank. Once the result set is returned, how do I search only on those returned records to find the ones where the city is not equal to Vancouver? I tried using the and function with one search and it returned records with a city of Vancouver.