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

    Function to find the most frequent value in a related table


      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.