Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

report between unrelated tables

Featured Replies

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

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

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

Why not combine Expenses and Deposits into one Transactions table?

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.

  • Author

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

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.