Selecting Most Used Name

[Dalceon]

Here's what I need.
I dump a bunch of id's and names into a table. The id's are unique, but the name's aren't because of spelling and such.

for example my table would look something like this.

ID Name

1 John
1 Jon
1 Jon
1 Jon
1 Jon
1 Jon
1 John

Since the ID is unique, I can group by it in a report to get the information I Need. Also in the report, I want to show the most commonly used Name In the report. How can I make a query or the report to only show me the most common name.

thanks