Specific record counting in Reports

[Duncan]

In the past I have used =Count(*) in a txtbox in the report footer to count all the records. Now I want to only count records that have the value of N in a field or if a check box is checked.


E.g.,
Table name: tblclients
Field name: txtpresent
Data in filed either: N or C and I only want to count the N

I’m currently playing with =count([tblclients.txtpresent].[value] = N) to no success

Alternatively I have a check box field in the report I could count
Any help would be most welcome

[June7]

If you want to count the form's RecordSet, try:

=Count(IIf([txtpresent]="N",1,Null))

Counting on the table would require DCount.

[Duncan]

Excellent worked first time and I wound of never got that. May thanks June7.