Count(Field;searchstring)???

[wireshop]

I want to count how many records in the database have a certain value in a certain field and display this on my layout.

How would I do that?

Thanks in advance

[Lee Smith]

Read about Pattern Count Function. Help Link

[Fitch]

This question comes up in various forms all the time. The classic way to do it is to create a calculated field e.g.

Field = "certain value"

And then you'd sum or summarize the calc field.

However, recently I came across TypeSumField, a custom function that looks like is designed to solve this exact problem. I haven't tested it myself yet.

Note that you'll need to use FileMaker Advanced to set up the custom function in your file, but you don't need FMA to actually use it.

[David Jondreau]

TypeSumField has issues...I don't think I ever worked out a good way to account for null values using the counting technique. But it has potential...if I ever get around to fixing it.

Oh, it looks like Bruce R took a shot at that.

Thanks!

Edited July 26, 2008 by Guest