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

Read about Pattern Count Function. Help Link

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.

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, 200817 yr by Guest