>I grouped my data by month and what I want to do is that I want to set the data to 0 if it is not the last record in the group like shown below, what can I do? Or can report do that?
>
>Jan
>Mr. A $10000 <--- want to become 0
>Mr. B $20000
>Sum1= 30000
>Feb
>Mr. A $2000 <--- want to become 0
>Mr. B $3000 <--- want to become 0
>Mr. C $4000
>Sum2= 9000
>----------------------------
I don't understand why you would want to do this. What are you trying to accomplish and why? Maybe there is a better way than what you are thinking.
Cathy