<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=500591504-13032007><FONT face=Arial
color=#0000ff size=2>You could use a group query and from memory you could sort
the result by count(group).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=500591504-13032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=500591504-13032007><FONT face=Arial
color=#0000ff size=2>Laurie</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Jones, Mark
A<BR><B>Sent:</B> Tuesday, 13 March 2007 2:15 PM<BR><B>To:</B>
itapps@edulists.com.au<BR><B>Subject:</B> [Year 12 IT Apps] Access
question<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial color=#000000 size=2>Dear all</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm looking for a function (for a query or report)
that will search a list of names then provide the name of the most numerous one.
Any ideas would be appreciated.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Mark Jones</FONT></DIV>
<DIV><FONT face=Arial size=2>Cann River P-12 College</FONT></DIV>
<P></P>
<P><B>Important - </B>This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before opening or
using attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or not,
resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender, and
not necessarily those of the Department of
Education.</P>_______________________________________________ <BR><A
href='ttp://www.edulists.com.au"'>http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>IT Applications Mailing List kindly
supported by <BR><A href='ttp://www.vcaa.vic.edu.au"'>http://www.vcaa.vic.edu.au
</A>- Victorian Curriculum and Assessment Authority and <BR><A
href='ttp://www.vitta.org.au"'>http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc</BODY></HTML>