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!

 

Cheers,

Rich

Outcomes