Combine data from one table

[Ray67]

Ok so this is what i did Balance: ([SumOfCharges])-([SumOfPayments])-([SumOfAdjustments])
and it didn't change anything.

[June7]

Not seeing the Round() function in that expression.

Round([SumOfCharges]-[SumOfPayments]-[SumOfAdjustments],0)

[Ray67]

it does take away negative value to 14 decimals but it's rounding off the number.
Is there any other way to fix this. I really need it to show the true value

[June7]

Replace 0 for however many decimals you want.

Seems to me the number you posted as example is essentially 0.

[Ray67]

For the ones that do have a balance it's rounding them of.

Thank you it works now.