"Alex Ferenstein" <alexdok[at]internode.on.net> wrote in message
news:3ffa935d$1[at]duster.adelaide.on.net...
- quote -

Sorry, that should be:
"whereas I should get ($C-$A)-($D-$B)=-$A => $C=-($B-$D) (since 'charges'
are"

I'm using Trial version of 2004 Internation edition (my copy is in shop
awaiting collection).
My am looking at one of my charge accounts... When I view account "Sorted by
Date (Increasing)", my balances per transaction are fine and add up to what
I expect.
However, if I change the sorting to "Sorted by Date (Decreasing)", the
individual balances make no sense - the transaction amounts and the balances
don't coincide nor add up. There is some crazy pattern though...
For example, in the table:
Latter transaction, $C, shown balance is $D
Early transaction, $A, shown balance is $B
Then, I see a pattern: ($C-$A)+($D-$B)=$A => $C=2x$A-($B-$D)
whereas I should get ($C-$A)+($D-$B)=-$A => $C=($B-$D) (since 'charges' are
positive numbers).
I don't get this crazy maths when I sort "Sorted by Date (Increasing)"
Are Microsoft engineers crackers, or I am supposed to see some logic in
this?