December 14, 200520 yr I have two separate tables, Expenses and Deposits, that are not related. How can I create a report to calculate their balance?
December 14, 200520 yr 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. :
December 14, 200520 yr Author 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.
December 14, 200520 yr 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.
Create an account or sign in to comment