3 Replies Latest reply on Mar 31, 2014 8:55 AM by coherentkris

    Function to find the most frequent value in a related table

    JulianJohnson

      Hi There,

       

      I have to find the most frequently occuring value in a related table and was looking for a Mode function but can't find one.

       

      Basically, I have a table of people and a related table of the courses they have been on with the location in. I need to return the location they have taken the course in the most frequently. Am I missing something obvious?

       

      Thanks in advance.

      Jules