report between unrelated tables

[musicarteca]

I have two separate tables, Expenses and Deposits, that are not related. How can I create a report to calculate their balance?

[mr_vodka]

Can you provide any further information?

As it stands right now, you can either pass the values of the balances into global fields to print them, or you can create a third table that can join them to do it.

More information please. :

[musicarteca]

I have two tables, on the table "expenses" I enter the date of the expense, the amount, and related information, on "deposits" I enter the date of the deposit, the amount, and related information. Both deposits and expenses could be entered into one of two accounts.

I want to create a montly report that summarizes the balance of deposits minus expenses of each account.

[comment]

Why not combine Expenses and Deposits into one Transactions table?

[mr_vodka]

I was going to recommend the same thing comment has already suggested.

You can have it in the same table and if you want add another field that allows it to categorize it as either a Deposit or Expense.

[musicarteca]

Yes, I think that might be the best way to go. Thanks.