Report from two different queries?

[Guest]

I am working on a database that requires a report in which interest is a
cumulative total from 1/1/2007 thru todays date. The other information that
needs to go in the same report is the dollar amount of investments made in a
specific month. Both of these totals are associated with a fund number
(i.e., Fund 101 total investments for June would be 5,000,000.00 and the year
to date interest for Fund 101 would be 55,000.00. I have made two seperate
queries which provide me with the information but I can't seem to get a grasp
on how to make the report read Fund 101 Investments for June 5,000,000.00 and
year to date interest 55,000.

Thanks,
Sue

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ff34fc98dd&dg=microsoft.public.access.reports

 

[Guest]

Have you considered using one or more subreports?

 

[Larry Linson]

I am working on a database that requires a report in which interest is a
cumulative total from 1/1/2007 thru todays date. The other information
that
needs to go in the same report is the dollar amount of investments made in
a
specific month. Both of these totals are associated with a fund number
(i.e., Fund 101 total investments for June would be 5,000,000.00 and the
year
to date interest for Fund 101 would be 55,000.00. I have made two
seperate
queries which provide me with the information but I can't seem to get a
grasp
on how to make the report read Fund 101 Investments for June 5,000,000.00
and
year to date interest 55,000.

From the information you've provided, I can't give you an answer, either.
If we are to help you, we need not only information about what you need to
show in the Report, but about the data from which it can be shown -- not
just that you have "made two separate queries", but what the queries
contain. And, then, just maybe, we may have to ask you what's in the tables,
too.

And, in fact, I haven't quite determined whether you are reporting by day or
by month from what you describe. Something like "a detail line on the Report
should contain MonthName, YTDInterest (as of the last day of the month), and
Total Investments during the Month. The report is grouped by Fund, and shows
[only the current month | each month YTD]..." would be very helpful.

Remember, you have the database in front of you; we only have your
description from which to work.

Larry Linson
Microsoft Access MVP

 

[Guest]

Conceptually, if you have a parent record (a fund number) which these two
queries hold in common, your report would be based on the list of fund
numbers and have sub-reports based upon your two queries. The sub-report
control links by master report primary key and child report foreign key.

DoogieB