Function for finding most common entries
Posted: Mon Feb 14, 2005 11:40 pm
Hi all,
Basically I am wanting to find the most common value entered in a field, but I cant seem to find what I am after. Have searched all over but it is very hard to find something when you dont know if it can even be done.
All I can seem to get going is an average, which returns the result of a calculation as opposed to an actual row value.
Thanks.
Basically I am wanting to find the most common value entered in a field, but I cant seem to find what I am after. Have searched all over but it is very hard to find something when you dont know if it can even be done.
All I can seem to get going is an average, which returns the result of a calculation as opposed to an actual row value.
Thanks.