I have Filemaker pro 14. I have a database that has about 3,000 records. One field is called "student full names" and another is "characters played by students". Some students have played 1 character and others have played more than one. I have set up a count field and can sub sort by "student full names" which will return the number of "characters played by students". What I want is a way to count the number of "student full names" which would be less than the "characters played by students" as the students have played 1 or more characters.
Another way to ask is if I have 3000 addresses in the state of Texas, I want to be able to count how many addresses are in each city but also the number of cities in Texas I have addresses for.
Any help would be appreciated.