I
Iram
Hello.
I need to create a report that sums currency fields in two different tables.
Table tbl_Income has a currency field called Amount
Table tbl_Expense has a currency field called Amount.
I need to create a report kind of like this:
Total Income
Total Expenses
Balance (Total Income minus Total Expenses)
I would like to sum all of the income fields in table tbl_Income and put it
into the report field "Total Income" and the same for "Total Expenses" then
do a "Balance Field".
Could you help?
Thanks.
Iram/mcp
I need to create a report that sums currency fields in two different tables.
Table tbl_Income has a currency field called Amount
Table tbl_Expense has a currency field called Amount.
I need to create a report kind of like this:
Total Income
Total Expenses
Balance (Total Income minus Total Expenses)
I would like to sum all of the income fields in table tbl_Income and put it
into the report field "Total Income" and the same for "Total Expenses" then
do a "Balance Field".
Could you help?
Thanks.
Iram/mcp