run a report from 2 separate tables

[Kajinga]

How do I run a report using 2 tables that don't have a relationship



Essentially, I have a table for income and one for expenses
I'd like to run a report subtracting the expenses from the income to get net income etc

any help would be appreciated

[June7]

Could do a UNION query that would get all the records into one dataset.

Or use subreports, one each for income and expenses. Calculate total in each report footer. Then in a textbox on main form calculate the difference.

[Kajinga]

Oh ok - I like both ideas
I'm still very new at this, so I'll try both to get the idea

Thanks a million June7!