If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report from two different queries?
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/comm...access.reports |
#2
|
|||
|
|||
Report from two different queries?
Have you considered using one or more subreports?
-- Duane Hookom Microsoft Access MVP "skr" wrote: 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/comm...access.reports |
#3
|
|||
|
|||
Report from two different queries?
"skr" wrote in message ... 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 |
#4
|
|||
|
|||
Report from two different queries?
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 "Duane Hookom" wrote: Have you considered using one or more subreports? -- Duane Hookom Microsoft Access MVP "skr" wrote: 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/comm...access.reports |
Thread Tools | |
Display Modes | |
|
|