current status

i have one field contains cat and dog and bear.

i want to have a status how many dog and cat contains in the field.

do you know how to make it?
Hiroyuki TamuraField EngineerAsked:
Who is Participating?
billmercerConnect With a Mentor Commented:
I provided two different ways to do this. The normal way is to use a self-join relationship, and the Count() function to count how many records match a given word. The other way uses the GetSummary() function in combination with a summary field.

I added some new fields and created relationships to show both methods.
EE messed up the link. Copy and paste the whole thing into your browser.
you already asked this one, didn't you??
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Uh, yeah, this is basically the same thing. Probably should delete one.
If every record can have only one value in this field, the natural FileMaker way to count this would be to make a summary report. To do it you need to make a layout with "subsummary when sorted by [the field]", add a summary field to count records, sort records by this field, and then print them out. FileMaker has a wizard to do such reports; it starts when you add a new layout. Do you need more detailed instructions on how to make such a report?
Hiroyuki TamuraField EngineerAuthor Commented:
than ou, all:)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.