>Hilmar:
>
>Your SQL will sum all the deposits and withdrawas for each acct. That's not what I want. I want to show each individual withdrawal and deposit. If I have more withdrawals than deposits, then I want 0 to appear in the deposit field and vice versa.
Yes, you are right. I didn't look at the sample with enough attention.
Looks like you will have to write a loop to get this exact result.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)