Combining Two reports into one.

[Mike Abbott]

Can an expert please help tell me if this is possible and which part of the
manual / help file to look.

I have an income table / query and report

I also have an expenses table / query and report

Both work fine.

I use a simple parameter query to select the period for the report.

Is it possible to produce a "profit / loss report"

Where I can have the whole set of data sorted by date,

one column for income
one column for expenses

Similar to the example below.

I haven't delved into the mysteries of SQL so far

by the way the date is UK format.

Date Income Expenses

2/11/5
details value

2/11/5
details value


Then total income total expenses

profit loss for period.

Regards


Mike

 

[Duane Hookom]

I would create a union query of the income and expenses. You can then build
a single report from the union query.