AnsweredAssumed Answered

Am I missing something with this simple SQL calc?

Question asked by RichardStuart_2 on Dec 2, 2015
Latest reply on Dec 2, 2015 by RichardStuart_2

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!