SUM for calculated field on report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deki - 28 Oct 2005 23:36 GMT

Hello!
I have a report named rptLoansErrorRateReport. Textbox "ErrorCount" in
Detail section of this report has Control Source:
=DCount("ValidError","ErrorTable","NameID=" &
[Reports]![rptLoansErrorRateReport]![cboNameID] & " AND
(ErrorTable.ValidError)=-1").
How can I get SUM in Report Footer for "ErrorCount" textbox?

Signature

Deki PA

Reply to this Message

Marshall Barton - 29 Oct 2005 04:04 GMT

>I have a report named rptLoansErrorRateReport. Textbox "ErrorCount" in
>Detail section of this report has Control Source:
>=DCount("ValidError","ErrorTable","NameID=" &
>[Reports]![rptLoansErrorRateReport]![cboNameID] & " AND
>(ErrorTable.ValidError)=-1").
>How can I get SUM in Report Footer for "ErrorCount" textbox?

Pace an invisible text box named txtRunErrCnt next to the
ErrorCount text box. Set its Control source expression to
=ErrorCount and it RunningSum property to Over ALL.

Then the report footer text box can display the total by
using the expression =txtRunErrCnt

Note that your DCount could be a little shorter:
=DCount("ValidError","ErrorTable","NameID=" _
& Me.cboNameID & " ANDValidError=-1")

Signature

Marsh
MVP [MS Access]

Reply to this Message

Deki - 31 Oct 2005 16:01 GMT

Works perfect! Thank you Marsh!

Signature

Deki PA

> >I have a report named rptLoansErrorRateReport. Textbox "ErrorCount" in
> >Detail section of this report has Control Source:
[quoted text clipped - 13 lines]
> =DCount("ValidError","ErrorTable","NameID=" _
> & Me.cboNameID & " ANDValidError=-1")

Reply to this Message