I have a problem with making a search on a FORM with 334 records.
I am searching for text in the FIELD “Study”. Using “does contain”
If I search for Gary I get 40 records
If I search for Jerry I get 16 records.
If I search for Gary OR Jerry I get 55 records – which is correct because one record has both names.
If I search for the the following using “does not contain” I get the following.
Searching for Gary OR Jerry I get 333 records.
What am I doing wrong? look at the attached picture.
Attachments:
You must be
logged in to view attached files.
Hi Glen,
Add the same Study field again by clicking the + button and do a second rule instead of combining them all into one rule.
And since you have Any selected, then Tap Forms will do an OR comparison of the records.
Thanks,
Brendan
Not true. It will only work if I select “All”. “Any” doesn’t work.
That section in the manual about All and Any and when you use “OR” doesn’t make any sense unless you know what it is supposed to say I guess. Some examples might get across the idea of the functions.
I finally got it to work using separate lines of commands and “ALL”.
I’m glad you got it working.
.
