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
thanks in advance for your help