Joined: 03 Nov 2009
Online Status: Offline
Posts: 48
Topic: searching by keyword in field Posted: 15 Apr 2013 at 3:10am
Good morning,
Is it possible to search a field by a keyword?
For example,I have 10 records with 3 field
Name
Age
Note
I would like to search all persons named Jim that are 42 with the word "tattoo" in the note field. Is that possible since Note field isn't a selection, its free text?
I assume you mean that you created 3 parameters that you use in your record selection? In that case it is possible, you just have to set the 'Use custom value' to yes in your parameter.
However, you will probably have to change your record selection formula then, because you will have to check if a part of the field is Tattoo.
you could change it to something like
InStr({table.field}, {?Note}) <> 0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum