What "front end" is that? Do you want a count of the number of different company names present in the table or the numbers of times that a specific company name is present in the table?
To count the number of different company names are present in a given table: A new way to count unique values in FileMaker 12
To count the number of times a particular company name is present in the table:
Select Count ( \"CompanyName__lxt\" ) From \"Your Table Here \" WHERE \"CompanyName__lxt\" = ? ; "" ; "" ; YourTable::CompanyName__lxt )
Perfect! Thank you!
I needed the latter calc to count the number of times a specific company name is present in the table. I touched it up below so other users can cut-and-paste it; I saved it as Number, unstored:
COUNT ( CompanyName__lxt )
WHERE CompanyName__lxt = ?"
; "" ; "" ; JOB::CompanyName__lxt
The \" \" characters were there for a reason. Your names didn't need it but it's often necessary to quote field and table names inside an ExcuteSQL query and it's a good practice to simply quote everything in order to avoid the infamous ? result you'll get if a name is a reserved word or has characters (such as spaces and leading underscores) that the SQL query doesn't like.