2 Replies Latest reply on Dec 2, 2015 1:17 PM by RichardStuart_2

    Am I missing something with this simple SQL calc?


      I'm trying to count the number of unique values in a field named _1a_DemoKnowledgeContent_value__lxt (in the table, DANIELSON_FORM) using the SQL calc spelled out on this FileMaker Support Page: Counting the number of unique values in a field | FileMaker, but I just can't get it to work; I have it entered thus:


      ExecuteSQL ("SELECT COUNT ( DISTINCT _1a_DemoKnowledgeContent_value__lxt ) FROM DANIELSON_FORM" ; "" ; "" )


      Here's FileMaker's:


      ExecuteSQL ("SELECT COUNT (DISTINCT LocationField) FROM ContactTable" ; "" ; "")


      ...and yes, it's Unstored.


      So, is there something I'm missing in the set-up? TIA for your help!