>hi all,
>
>i have table as..
>

>empno telno name val 
>1     123       a     10
>1     223      a     15.30
>2     432       b     30
>2     567       b     10.50
>.
>.
>

>**************************i need result as
>

>
>       1     123       a     10
>             223       a     15.30
>tot                         25.30
>       2     432       b     30
>             567       b     10.50
>tot                          40.50
>
>

Assuming this is for a report, set up a group in the report on empno, and in the group footer, put an expression that sums val.

Tamar