hi,

how can i sum my amount field if this is the case?

person  income1     income 2       expense 1      expense 2
A,            1.5             2.5                    1.0               1.0 
B             2.0            1.0                    0.5               1.50            
B             1.75          3.0                    2.0               0.75
C             1.4             1.0                    0                    0

i'm using a stored proc that produces several duplicates like in the case above which have 2 records of "B" person.

my report should look like this:

person    total income
A               2.0
B               3.0
C               2.4

can anyone help? thanks.

oh, i havent indicated in my first post how i got the total income.

wow! thanks. it works!