I have two tables:
Revenue table
Revenue ID
Revenue_Date
Revenue_Description
Revenue_Value
Expenditure table
Expenditure ID
Expenditure_Date
Expenditure_Description
Expenditure_Value
How do i create a report that will display total Revenue_Value - total Expenditure_Value = balance
Sorry...
How do i create a income and expense database that will give me sequential numbering for both income and expenses. And a final balance. (income - expense). Sorry in advance for being a noob.