I have 2 Tables - Income and Expenses.
I've created 2 Queries - Income Summary and Expense Summary.
These give me a Month by Month Summary. Then I use Totals to get the Monthly Total.
How do I create a Query that will combine the above 2 Qs and give me a Inc/Exp Summary, so I can see whether I saved that month or spent more than I earned. Like P&L Statement. Thanks.
I've created 2 Queries - Income Summary and Expense Summary.
These give me a Month by Month Summary. Then I use Totals to get the Monthly Total.
How do I create a Query that will combine the above 2 Qs and give me a Inc/Exp Summary, so I can see whether I saved that month or spent more than I earned. Like P&L Statement. Thanks.