Count Problems

[Guest]

Hi,

I am trying to complile a report (or form) based on many counted Fields. I
have a Parameter based query [Stats Transfers From To] that compiles the
records betweens two dates. I then use that query to count records that meets
certain criteria.

Exemple: Value = Count("[Stats Transfers From To]![From Account Code Letter]
= 'N' And [Stats Transfers From To]![To Account Code Letter] = 'N'"]

It works but it always return the total amount of records in the query
result not just the records that meet the criteria. What am my missing?

Any help would be appreciated.

Thanks,
Marc

 

[Duane Hookom]

Count always counts all non-null values. This includes both True and False
values.

Value = Sum(Abs([From Account Code Letter] = "N" And [To Account Code
Letter] = "N"))

This expression would count the number of records where both the From... and
To equal "N".