Sum Problem
in [Reports]
|
From: Martin on 2 Jul 2008 12:37 I have a control called TreatWeeks in the Detail section of a report. Its ControlSource is: =Int([LOSDays]/7). This produces the desired result in the Detail section. In the Report Footer secion, I created a control with a ControlSource of: =Sum([TreatWeeks]). When I run the report, I get an Enter Parameter Value window for the TreatWeeks value. If I do not have this control in the Footer, everything is fine. Can someone tell me why I am getting the Parameter prompt when the control exists in the report? Thanks.
From: fredg on 2 Jul 2008 12:52 On Wed, 2 Jul 2008 09:37:00 -0700, Martin wrote: > I have a control called TreatWeeks in the Detail section of a report. Its > ControlSource is: =Int([LOSDays]/7). This produces the desired result in > the Detail section. > > In the Report Footer secion, I created a control with a ControlSource of: > =Sum([TreatWeeks]). When I run the report, I get an Enter Parameter Value > window for the TreatWeeks value. If I do not have this control in the > Footer, everything is fine. > > Can someone tell me why I am getting the Parameter prompt when the control > exists in the report? > > Thanks. Repeat the actual calculation, rather than summing the [TreatWeeks] control. =Sum(int([LOSDays]/7)) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
From: Martin on 2 Jul 2008 13:02 Thanks for the response, but now the Parameter prompt appears for LOSDays. "fredg" wrote: > On Wed, 2 Jul 2008 09:37:00 -0700, Martin wrote: > > > I have a control called TreatWeeks in the Detail section of a report. Its > > ControlSource is: =Int([LOSDays]/7). This produces the desired result in > > the Detail section. > > > > In the Report Footer secion, I created a control with a ControlSource of: > > =Sum([TreatWeeks]). When I run the report, I get an Enter Parameter Value > > window for the TreatWeeks value. If I do not have this control in the > > Footer, everything is fine. > > > > Can someone tell me why I am getting the Parameter prompt when the control > > exists in the report? > > > > Thanks. > > Repeat the actual calculation, rather than summing the [TreatWeeks] > control. > =Sum(int([LOSDays]/7)) > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail >
From: Jeff Boyce on 2 Jul 2008 13:39 Martin Pardon my intrusion... Spelling counts. If Access gives you a prompt, it means it doesn't recognize the control/field name. Re-check the spelling of the field... Regards Jeff Boyce Microsoft Office/Access MVP "Martin" <Martin(a)discussions.microsoft.com> wrote in message news:AEBE438E-B0AE-44A5-A9BF-16F1C24CFDD0(a)microsoft.com... > Thanks for the response, but now the Parameter prompt appears for LOSDays. > > > "fredg" wrote: > >> On Wed, 2 Jul 2008 09:37:00 -0700, Martin wrote: >> >> > I have a control called TreatWeeks in the Detail section of a report. >> > Its >> > ControlSource is: =Int([LOSDays]/7). This produces the desired result >> > in >> > the Detail section. >> > >> > In the Report Footer secion, I created a control with a ControlSource >> > of: >> > =Sum([TreatWeeks]). When I run the report, I get an Enter Parameter >> > Value >> > window for the TreatWeeks value. If I do not have this control in the >> > Footer, everything is fine. >> > >> > Can someone tell me why I am getting the Parameter prompt when the >> > control >> > exists in the report? >> > >> > Thanks. >> >> Repeat the actual calculation, rather than summing the [TreatWeeks] >> control. >> =Sum(int([LOSDays]/7)) >> -- >> Fred >> Please respond only to this newsgroup. >> I do not reply to personal e-mail >>
From: Martin on 2 Jul 2008 14:03 Intrusion is welcome. However, I have checked spelling 3 or 4 times, compared to any reserved words, all with no result. This might sound crazy, but it seems like the only way a Sum will work is with a field/control directly from the record source. If there is a calculated control that needs to be summed, Access cannot handle it. The reason I say that is because I have other controls that are direct from the source and the sums work. Only the one that is a calculation will not sum. "Jeff Boyce" wrote: > Martin > > Pardon my intrusion... > > Spelling counts. If Access gives you a prompt, it means it doesn't > recognize the control/field name. Re-check the spelling of the field... > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > "Martin" <Martin(a)discussions.microsoft.com> wrote in message > news:AEBE438E-B0AE-44A5-A9BF-16F1C24CFDD0(a)microsoft.com... > > Thanks for the response, but now the Parameter prompt appears for LOSDays. > > > > > > "fredg" wrote: > > > >> On Wed, 2 Jul 2008 09:37:00 -0700, Martin wrote: > >> > >> > I have a control called TreatWeeks in the Detail section of a report. > >> > Its > >> > ControlSource is: =Int([LOSDays]/7). This produces the desired result > >> > in > >> > the Detail section. > >> > > >> > In the Report Footer secion, I created a control with a ControlSource > >> > of: > >> > =Sum([TreatWeeks]). When I run the report, I get an Enter Parameter > >> > Value > >> > window for the TreatWeeks value. If I do not have this control in the > >> > Footer, everything is fine. > >> > > >> > Can someone tell me why I am getting the Parameter prompt when the > >> > control > >> > exists in the report? > >> > > >> > Thanks. > >> > >> Repeat the actual calculation, rather than summing the [TreatWeeks] > >> control. > >> =Sum(int([LOSDays]/7)) > >> -- > >> Fred > >> Please respond only to this newsgroup. > >> I do not reply to personal e-mail > >> > > >
|
Next
|
Last
Pages: 1 2 Prev: duplicates within fields Next: Report Error for certain Crosstab Query |