AnsweredAssumed Answered

Doing Calculations Between Tables

Question asked by JimTrimble on Jun 30, 2011
Latest reply on Jul 1, 2011 by philmodjunk


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!