> Hi Group,
>
> I have a table that stores debit and credit transactions. At the
> moment, a positive value in the amount field means a deposit and a
> negative value in the amount field means a withdrawal.
>
> I need to display the total deposits, total withdrawals and balances,
> but using the current table structure that requires three subselects.
>
> This is obviously not an unusual problem, Is the way I have done it
> the best way to do it, or would it be better to have separate fields
> for debits and credits?
>
> TIA
>
> Adam
>

I always have a debit and a credit column. You can have -tive credits
and -tive debits unfortunately.
Closing periods is matter of posting an opposing balance - not a -tive
amount in the same column.
Alan