SUM for calculated field on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Deki said:
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?
Click to expand...


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")
 
Works perfect! Thank you Marsh!
--
Deki PA



Marshall Barton said:
Deki said:
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?
Click to expand...


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")
Click to expand...
 
Back
Top