9 Replies Latest reply on Sep 5, 2013 4:19 AM by smac11shl

    Count of Unique values in a field

    jthomas

      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.