AnsweredAssumed Answered

Get summary

Question asked by JohnRobin on Apr 2, 2015
Latest reply on Apr 2, 2015 by philmodjunk

Title

Get summary

Post

I'm new to filemaker and have a simple question.

I have a field "State". I want to create a new Filed "MI" that is the total count of records containing "MI' in the State field..

So if my layout looks like this the "MI" Field would return "2" records

State   Zip             Pieces

IL        60195            10

MI       45246             9

MI       45245             6 

Total MI   2

Outcomes