AnsweredAssumed Answered

search between 2 values

Question asked by microbatteryshop on Apr 24, 2012
Latest reply on May 23, 2012 by microbatteryshop

Title

search between 2 values

Post

hi, first i am completely new to filemaker. And staring to learn with each step. But this i cannot solve.

lets say i have a  table  as follows

result / minimum value / maximum value / system

A123 / 0 / 5 / NIMH

A47845 / 5 / 10 / NICD

a1684 / 5 / 10 / NIMH

A984 / 10 / 20 / NIMH

A5218 / 20 / 30 / NIMH

I have a field in a layout where i write "9 "and another "NIMH"

in the 3th field   I need the result.

so a search looks for the value 9 ( what is between 5 and 10)

and it must be NIMH. the result a1684 is written in my 3th field.

Ive looked everywhere for a solution as GET or Find or LOOP. And after 8 hours i give up. even youtube is not working

Is theire someone who can help me Laughing please

Outcomes