Sum(Abs)

[DEI]

I am writing a simple tabular report and would like to
total the number of records where "N" appears in field
titled [BDR]. I write the expression =Sum(Abs([BDR]="N"))
and keep getting a "#error" in the report.

This has worked before, I can't figure out what the
problem is.

Thanks in advance.

DEI

 

[Duane Hookom]

Your issue might be that your control name is the same as a field name,
possibly "BDR". Try change the name of the text box to "txtCountBDR_N"

 

[Roger Carlson]

Two things occur to me:
1) The Name of the textbox holding this expression is "BDR". (The name of
the control cannot be the same as the field in the expression)
or
2) You are trying to put this textbox in the Page Footer of a form. (It
won't work there. It must be in a group footer or report footer.)