I am wanting my query to just retrieve a subset of my database but it doesn’t work. I type what I am looking for in the criterion box, correct? When I do that all the records are returned and then what I typed has disappeared.
Thanks.
Hi
You give little information about you data, query and how you proceed.
Hard to help you… These wiki pages
Show how to do in common cases. If they do not respond to your question, please provide more details.
I have a query for 1 table with a field Firstname. In the Criterion row I type LIKE ‘jane’ or = 'jane. When I run the query I don’t just see Jane and the Criterion row becomes blank.
I can filter by Firstname LIKE Jane successfully
Jane
As indicated in one of the given links search is case sensitive. To allow the search to match the entered string in either upper or lower case (ie case insensitive), the field definition must have type definition “VARCHAR_IGNORECASE”. And,if you want to select all records starting with Jane must use the criterion LIKE 'Jane*'
That makes sense but I get the result. Nothing is shown and the criterion is blank after I run it.
I am using version 4.2 and MAC OS 10.9.5
I think I got bitten by the same thing. You must press “Enter” after typing in your criteria, otherwise the field will not be updated. If that’s not the cause, it might help to tell us the type of the field you are trying to filter, and what your criteria look like.