Is Not Null as a Operator? 1

[Stevehewitt]

Hi Guys,

I am trying to use the following as a source control on a text box to count the number of records in the report that have a entry in the "rejectreason" field:

=Abs(Sum([RejectReason]=["IsNotNull"]))

I know that I am doing something wrong in terms of the "IsNotNull" part, but I don't know what to do. MS Help isn't helping and I'm pretty confused. (Works fine in a query).

Thanks,


Steve.

 

[RoyVidar]

Try:

[tt]=Abs(Sum(not isnull([RejectReason])))[/tt]

Roy-Vidar

 

[Stevehewitt]

Spot on Roy, Thank You.

Cheers,


Steve.