Find with not equal question
I have a database with many banks with multiple records for each bank.
I need to be able to search for a specific bank in the bank field, and at the same time
search the status field, for all records that do not contain the text "closed".
Is there a way to do this?