My SQL Statement under my recordset is:

SELECT mmatter, (feest+costst)-(arwofft+oafeest+paymentt) as balance
FROM dbo.ken_juantable
WHERE linvoice = MMColParam
ORDER BY mmatter

TEST SQL Statement is
mmatter balance
3113-002 500.00
3113-003 1000.00
3113-004 2000.00

My problem is when I display it on my repeat region table in MX
I get my balance 500.00 on all three rows.

feest costst aweofft oafeest paymentt balance
250 250 0 0 0 500
500 500 0 0 0 500
1000 1000 0 0 0 500