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.