Doing Calculations Between Tables
Hi! I'm a newby so please excuse the basic nature of my question.
I've created an accounting database for my business. I have two separate tables or layouts:
"Invoices" - each record is a separate invoice with a summary field in the footer totaling income from all invoices.
"Expenses" - basically same as above with a summary field totaling all expenses.
I'm trying to create a third table or layout that will show a calculation "profit = total income - total expenses" from the summary fields of the other two tables. I know this should be simple, but I can't figure it out.
Thanks for you help!