If you are wanting a checkbook like display then each entry is either a
debit or credit and each is on its own line.
Your query will display this. I would add an ifnull to display a zero
when the the debit/credit is null.
Original Message
On 3/2/04, 10:50:15 AM, charles kline [EMAIL
Charles:
I am not quite sure by what you mean, How do I get it to show me as I
like, one in and one out per line, rather then an in for every out and
vice-versa?
It seems for your example below you want a result set of 4 rows
I don't think your design is appropriate, however your suggestion at
Boyd,
Thank you very much for the design help... this is just what I am
looking for, just wasn't clear how to best do it :)
BTW, you can use a case statement to help with signing the number
properly. I just discovered this the other day and am really tickled
with it!
I am not very experienced