AnsweredAssumed Answered

Count of Unique values in a field

Question asked by jthomas on Feb 11, 2013
Latest reply on Sep 5, 2013 by smac11shl

I have a table that lists the responses to a survey. The table contains a SurveyID and the responseId as well as the respone. The table contains about 8800 rows. There can be several responses different respones from the same survey. The table only contains the respones that were answered yes. I would like to be able to count the number of unique surveyID there are in the table. If i were doing this in Oracle I would use

 

select

Distinct Count (t.SurveyID) from

QuestionsImportedfromAccess t;

 

 

 

I tried this in Filemaker 12 ExecuteSQL and it doesn't seem to work. I added the following to a calulated global field:

ExecuteSQL (" select Distinct Count (SurveyID) from QuestionsImportedfromAccess";"";"" )

 

only returns ?

 

 

Any help would be greatly appreciated.

Outcomes