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.
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*'
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.
Asked: 2015-02-22 05:10:49 +0100
Seen: 1,505 times
Last updated: Feb 22 '15
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
