AnsweredAssumed Answered

Counting yielding incorrect answer ?

Question asked by BrianBrouillette on Feb 13, 2014
Latest reply on Feb 13, 2014 by philmodjunk


Counting yielding incorrect answer ?



        I am trying to count unique values in a field using the ExecuteSQL command  - the command "works" but yields the incorrect answer  (on a list of 19 records, there are 6 unique names and my query shows 7 --hence my post....


        THe query I am using is ExecuteSQL ("SELECT COUNT (DISTINCT\"Customer\"FROM \RE Plan 2.0 Converted|"";"";"")

         The field Customer is set to Text  and "always validate , custom values list 


     any ideas?

     thanks in advance for your help