Counting in Reports

[Shue6842]

Hello, I am sure this is an easy problem to solve but can someone please help me with the correct formula to count specific data within a field? Below is the formula that I am using to count.

=count([Club])

This formula counts everything in the field. I want it to break it down more specifically.

[Club] is the field that holds the data that I want to count. For example I want the report to count the total number of 0311T records.


Sent from my iPhone using Tapatalk

[pbaldy]

If it's just the one, in the report footer:

=Sum(IIf([Club] = '0311T', 1, 0))

[A S MANN]

Use =DCount("[Club]", "Table", "[Field] = 'CA'")

[pbaldy]

Use =DCount("[Club]", "Table", "[Field] = 'CA'")

Note that will count all matching records in the table, not necessarily those on the report if it was filtered in any way.