AnsweredAssumed Answered

Finding closest value.

Question asked by braveintern on Mar 26, 2010
Latest reply on Mar 26, 2010 by ninja


Finding closest value.


I am a beginner using Filemaker Pro 8.5 on Mac OSX 10.5.8.  I have been tasked with creating a database for my companies interns, volunteers and freelance workers.  My boss requested that he can find not only specific values but values closest to the value searched.  For example, lets say that he wants to find out what we have paid a freelancer in the past for a certain tast, and I have a field that lists how much we have paid freelancers in the past.  He is willing to hire someone for $50 dollars so he performs a find in the wage field but we have never hired someone who works for exactly $50 dollars.  Is there a way to perform a search where the results would list values closest to $50 for example $49, $42, $35 dollars from closest value to furthest from the specified target?