AnsweredAssumed Answered

Find values between

Question asked by Kaps on Oct 24, 2015
Latest reply on Oct 28, 2015 by Mike_Mitchell



I have a calculated field which correctly computes the age next birthday of a person. I want to allow the user to find those records where for example the age next birthday is between 50 and 70. I have assumed that the user has no knowledge of filemaker whatsoever, so he is guided by scripts.


The first button the user presses activates a script that puts the user in FIND mode.


The user can then enter say >50 to specify the first request,


The user can then press a button to specify a new request.


He can then enter <70 to specify the second criteria.


He then presses a third button to perform the find.


However the results returned are not correct.


If the user enters only a single request e.g find those above 50 then I get the correct answer. However multiple requests do not seem to get me the correct answer.


Can anybody help ? Thanks


kind regards