AnsweredAssumed Answered

Find values between

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

Hi,

 

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

Kaps

Outcomes