Re: Query a List

Qazi Anis — Tue, 24 Nov 2009 06:59:53 GMT

modify if X > -1 then Fund Result = 1000

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

Query a List

ramii — Mon, 23 Nov 2009 17:31:31 GMT

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

Newbie Questions

Re: Query a List

Query a List