Multiple record sources in 1 report

A

Andreas

I have a table with expenses and a table with income. I want to design a
report in an accounts style (i.e expenses to the left, income to the right)
and then make calculations between the 2.

If I design a query to join the 2, then the expenses and income will be
mixed. It's clear to me that I have to use the 2 tables independently in the
same report. However, I can't imagine of a way to do this.

What's the best way to achieve this?
 
J

Jeff Boyce

Adreas

This may not be what you are looking for...

Can you create a report that only does the Expenses?

Then create a report that only does the Income?

When those two are working (independently) correctly, create a third (empty)
report.

Open it in design view.

Embed each of the other two reports as "sub-reports" in your main (empty)
report.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
A

Andreas

Is this possible? How can I define sub-report?

Will I be able to make calculations between the values of the 2 reports?
(i.e subtract expenses from income and calculate percentages)
 
J

Jeff Boyce

Andreas

Subreports are just reports that you've embedded in another report.

I got the impression from your original post that you did NOT want to have
related records ... that would be the primary way to calculate "between".

Perhaps if you posted a description of your underlying data, it would help
the newsgroup readers get a handle on what we are working with...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
A

Andreas

No, I don't want relations. I just want to do calculations on the final
results. I.e subtract totals of the one table from totals of the other. That
could be referenced by the controls, I assume
 
J

Jeff Boyce

Andreas

Take a look at using =Sum([YourAmountField]) in unbound controls in the
headers or footers of your subreports. These total up the amounts for your
Income and your Expense reports.

Then, in your main report, add an unbound control in which you refer to the
amounts shown in the subreport summary controls.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top