scenario related to finance??

[#1]

hi to all

this is siva

if i have data like this

account no     closing balance

1                     50000

2                     45000

3                     25000

4                     51000

5                     60000

6                     80000

if i  input   account no's 2,5.6 ,the text box has to show closing balance of those selected account no's

this task has to achieved by using input box.

without using any sheet object  other than input box and text box

thanks in advance

[sushil353 · Accepted solution]

Hi,

Store the values of input box in a variable say vAccount.

and the in text box:   sum({<accountno = {'$(vAccount)'}>}closingbalance)

HTH