Jump to content

report between unrelated tables


This topic is 5762 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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. :

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5762 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.