Function to find the most frequent value in a related table

Discussion created by JulianJohnson on Jun 20, 2013
Latest reply on Mar 31, 2014 by coherentkris

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.