Re: I need to add two text boxes from two different reports.
- From: Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Feb 2008 10:41:00 -0800
The DSum should be in the report, not in the query.
Also you do not need a query for each month. You are creating yourself a
maintenance nightmare. A better way is to determine the month you want the
report for and use that in the DSum's criteria argument. Since I don't know
your data or your report, I can't give an exact solution, but let's say for
example purposes you have a text box control on your report that contains the
month for the report in numeric format (1 = Jan, 2 = Feb, etc) Use the
control source of the text box you want to put the value in:
=DSum("[SomeField]", "ATableOrQuery", "Month([DateField]) = " &
Me.txtReportMonth
--
Dave Hargis, Microsoft Access MVP
"Shawna" wrote:
So should I create the dsum expression in the query I am using for the.
reports? I tried to sum the two records but it is not working in the query.
I need to sum my office hours with my phone hours. Then the result of that
needs to be added to the same result every month. I have created a query for
every month. All this from one table.
"John Spencer" wrote:
I would not attempt to do it this way. It may be impossible, but for
starters, both reports would have to be open for you to get a value from
another report.
A better way would be to use a DSum statement that gets the value you
need from the underlying query of Service Records October 2007 report.
Since I have zero idea of what that underlying query or table might be I
can't give you any more detailed advice.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Shawna wrote:
In one report, the box is the total of hours in the report, the second report
is the same. I need to add the hours from both reports and include it in
another text box. Here is the expression that I am using (all is spelled
correctly)
=([TotalHoursForwardNov])+(Reports![Service Records October
2007]!TotalUnusedHoursOct)
"Evi" wrote:
"Shawna" <Shawna@xxxxxxxxxxxxxxxxxxxxxxxxx>
I am adding a value from one monthly report to another monthly report. IGive us a few more details. What are you typing into your text boxes? You
keep getting #name. Please help!
can't actually add up things in 2 different reports - reports are just ways
of showing data - I'm guessing that you are really adding up things from a
table. A common cause of the #name error is when you are trying to refer to
a control in say a form and you type the name of the form wrongly.
Evi
Evi
- References:
- Prev by Date: Export report running under runtime
- Next by Date: Re: Actual vs Scheduled report
- Previous by thread: Re: I need to add two text boxes from two different reports.
- Next by thread: Re: Include totals in footers to fields in layout collection (2007)
- Index(es):
Relevant Pages
|
