I have been trying to create a count of unique values in a table. The way I am approaching it is through ExecuteSQL in:
I have one table that I'm using that has a field called "EmployeeID". I created a field called countEmployeeID = ExecuteSQL ("SELECT COUNT (DISTINCT EmployeeID) FROM CallType" ; "" ; "")
CallType is the table name in relationship view.
The problem is that it returns a "?". I've looked at SQL forums and it appears my syntax is correct. What else could I be missing?
Edit: I checked to not store the value and recalulate when needed. It now provides me a number but this number does not change when I refine the search. Is this normal or is there a way to create a unique find on a found set?