InfoPath Dev

Hi all,   

I have a List to be queried based on  Initial Amount selected. I had a data connection to query the list.

Details:  Initial Amount  =  X amount   ( Decimal )

TestList:
Title                Keyword           Value1    Value2   (all are single line of Text )
FormName       Amount               -1           1000
FormName       Amount               300         2500
FormName       Amount               550         4000
FormName       Amount               1000       10000

Fund Result  =  ( Value2 based on  X amounts..). Value1 and Value2 cannot be hard-coded. They may change over a period of time on the List. I have to query the TestList  on Value1 based on FundResult(X).

If        X > 1000             then    Fund Result  = 10000
          X > 550 &  X < 1000  then    Fund Result  = 4000
          X > 300 &  X < 550   then    Fund Result  = 2500
else if   X > -1   then  Fund Result  = 1000

 I tried the queries where I am getting only Value2 as 1000 everytime.  Any ideas are appreciated.

 Thanks,
Ramii

modify if   X > -1   then  Fund Result  = 1000

if   X > -1 & X < 300  then  Fund Result  = 1000