AnsweredAssumed Answered

Unique Count

Question asked by FileMakerNovice on Aug 5, 2013
Latest reply on Aug 6, 2013 by philmodjunk

Title

Unique Count

Post

     Hello,

     I have been trying to create a count of unique values in a table.  The way I am approaching it is through ExecuteSQL in:
     http://help.filemaker.com/app/answers/detail/a_id/3423/~/counting-the-number-of-unique-values-in-a-field

     I have one table that I'm using that has a field called "EmployeeID".  I created a field called countEmployeeID = ExecuteSQL ("SELECT COUNT (DISTINCT EmployeeID) FROM CallType" ; "" ; "")
     CallType is the table name in relationship view.

The problem is that it returns a "?".  I've looked at SQL forums and it appears my syntax is correct.  What else could I be missing?

     Edit:  I checked to not store the value and recalulate when needed.  It now provides me a number but this number does not change when I refine the search.  Is this normal or is there a way to create a unique find on a found set?

Outcomes