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 Totals
I have a report called Associated Fund Interest. It has a grand total in the
report footer. I also have a report called Monthly Investment by Fund Less Associated. This report has four fields: Fund Name, Fund Number, Face Amount and YTD Interest. The face amount and YTD interest both have grand totals in this report footer. I need to be able to take the grand total from the Associated Fund Interest report and subtract it from the YTD Interest in the Monthly Investment by Fund Less Associated report. I thought this would be one of the simpler things of the project but so far it hasn’t been. Any ideas would be appreciated. Sue |
#2
|
|||
|
|||
Report Totals
I would not create anything in one report that depends on another report
unless one is a subreport on another. Consider using queries, codes, subreports, or whatever to pull values to display in your report, not a separate report. -- Duane Hookom Microsoft Access MVP "skr" wrote: I have a report called Associated Fund Interest. It has a grand total in the report footer. I also have a report called Monthly Investment by Fund Less Associated. This report has four fields: Fund Name, Fund Number, Face Amount and YTD Interest. The face amount and YTD interest both have grand totals in this report footer. I need to be able to take the grand total from the Associated Fund Interest report and subtract it from the YTD Interest in the Monthly Investment by Fund Less Associated report. I thought this would be one of the simpler things of the project but so far it hasn’t been. Any ideas would be appreciated. Sue |
#3
|
|||
|
|||
Report Totals
I thought a subreport would be my answer but--Can I hide a subreport and just
use the textbox in the report footer or can I put the subreport somewhere else besides the detail section? "Duane Hookom" wrote: I would not create anything in one report that depends on another report unless one is a subreport on another. Consider using queries, codes, subreports, or whatever to pull values to display in your report, not a separate report. -- Duane Hookom Microsoft Access MVP "skr" wrote: I have a report called Associated Fund Interest. It has a grand total in the report footer. I also have a report called Monthly Investment by Fund Less Associated. This report has four fields: Fund Name, Fund Number, Face Amount and YTD Interest. The face amount and YTD interest both have grand totals in this report footer. I need to be able to take the grand total from the Associated Fund Interest report and subtract it from the YTD Interest in the Monthly Investment by Fund Less Associated report. I thought this would be one of the simpler things of the project but so far it hasn’t been. Any ideas would be appreciated. Sue |
#4
|
|||
|
|||
Report Totals
You can place a subreport in any section of a main report. You can set
sections to invisible in the subreport. -- Duane Hookom Microsoft Access MVP "skr" wrote: I thought a subreport would be my answer but--Can I hide a subreport and just use the textbox in the report footer or can I put the subreport somewhere else besides the detail section? "Duane Hookom" wrote: I would not create anything in one report that depends on another report unless one is a subreport on another. Consider using queries, codes, subreports, or whatever to pull values to display in your report, not a separate report. -- Duane Hookom Microsoft Access MVP "skr" wrote: I have a report called Associated Fund Interest. It has a grand total in the report footer. I also have a report called Monthly Investment by Fund Less Associated. This report has four fields: Fund Name, Fund Number, Face Amount and YTD Interest. The face amount and YTD interest both have grand totals in this report footer. I need to be able to take the grand total from the Associated Fund Interest report and subtract it from the YTD Interest in the Monthly Investment by Fund Less Associated report. I thought this would be one of the simpler things of the project but so far it hasn’t been. Any ideas would be appreciated. Sue |
Thread Tools | |
Display Modes | |
|
|