i have an expense report and an income report. how do i show a report with income minus expenses
How have you set up your table(s) to record income and expenses?
How did you set up the report?
i have an expense report with sub summaries and a trailing grand summary and i have an income report with the same.
is it possible to take the grand summary of the income report minus the grand summary of the expense report and show net profit or loss
It's certainly possible to compute total income - total expenses. HOW you do it depends on the structure of your database on your report.
I think you've used separate tables, one for expenses and one for income. It's actually easier to store this information in one table with a field for income and a field for expenses.
Using the tables I think you have, you'll need to answer another question. Are total expenses total income always going to be the total of all the records in their respective tables or only records from a specific range of dates (The year 2009, 3rd quarter 2009, January 2010--to giv a few examples)?
Retrieving data ...