AnsweredAssumed Answered

How do I do this?

Question asked by KarlSchaeffer on Aug 9, 2018
Latest reply on Aug 11, 2018 by KarlSchaeffer

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.

 

Thanks!

Outcomes