Count Problems

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

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
 
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".
 
Back
Top