simple sum of two values

[kit_sune]

This should be an easy one.
I have a query I'm working on. I use three tables to pull my data.

WorkTracker - each record is a date, worker name, and chore name completed
Chores - list of chores and the allowance received for each
Transactions - date, child, and money spent

I have a query that pulls the sum of transactions and the sum of allowance given but I don't know how to add them together.

I'm on a mobile right now but if specifics are needed I'll post that.

--- Edit ---

Actually, I think I figured it out. At least it seems to do what I wanted!

I'm adding the SQL statement in that the query wizard shows:

SELECT DISTINCTROW WorkTracker.Worker, Sum([Allowance]+[MoneyTransfered]) AS Balance
FROM Transactions INNER JOIN (Chores INNER JOIN WorkTracker ON Chores.[Chore] = WorkTracker.[Chore]) ON Transactions.Customer = WorkTracker.Worker
GROUP BY WorkTracker.Worker;