Just a thought on how you may be coming up empty.

Could it be that you are not being as precise as needed in filters when you use "And" and "Or"? In English, you can say "Show me the clients in CA and NV" and people would understand that you want to see the clients in CA and the clients in NV, but the computer interprets it as "Show me any client who is in both CA and NV". Since no client record can be in CA and in NV at the same time, your filter won't let any records through.

What you need to say is "Show me the clients in CA or NV" which will be interpreted as "Show me any client in CA and show me any client in NV".

Make sense?