<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micro=
soft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" xm=
lns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://www.w=
3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"PlaceTy=
pe"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-AU link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>This sort of task could be done by use=
of
a code.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>This could be done by building an Event
code module or a macro code.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Event code would require the use of rec=
ordsets
and a function called DCOUNT(XXX,XX,XXX)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>There are standard example procedures g=
iven
in the online help at Microsoft.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=3D=
'font-size:
10.0pt;font-family:Arial;color:navy'>Another way would be to build a grouped
report and have a text box that has =3Dcount(field_name) positioned in the
field_footer part you are counting.<o:p></o:p></span></font></p>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font size=
=3D3
face=3D"Times New Roman"><span lang=3DEN-US style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span><=
/font></b><font
size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:10.0pt;font-fam=
ily:Tahoma'>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b><s=
pan
style=3D'font-weight:bold'>On Behalf Of </span></b>Jones, Mark A<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Tuesday, 13 March 2007=
2:15
PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> itapps@edulists.com.au<br=
>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Year 12 IT Apps] Ac=
cess
question</span></font><span lang=3DEN-US><o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:black'>Dear all</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:10=
.0pt;
font-family:Arial'>I'm looking for a function (for a query or report) that w=
ill
search a list of names then provide the name of the most numerous one. Any
ideas would be appreciated.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:10=
.0pt;
font-family:Arial'>regards</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:10=
.0pt;
font-family:Arial'>Mark Jones</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><st1:place w:st=3D"on"><st1:PlaceName w:st=3D"on"><font=
size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>Cann</span=
></font></st1:PlaceName><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'> <=
st1:PlaceType
w:st=3D"on">River</st1:PlaceType></span></font></st1:place><font size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'> P-12 Colleg=
e</span></font><o:p></o:p></p>
</div>
<p><b><font size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0p=
t;
font-weight:bold'>Important - </span></font></b>This email and any attachmen=
ts
may be confidential. If received in error, please contact us and delete all
copies. Before opening or using attachments check them for viruses and defec=
ts.
Regardless of any loss, damage or consequence, whether caused by the neglige=
nce
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.=
<o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D'=
font-size:
12.0pt'>_______________________________________________ <br>
<a href=3D"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=3D"ttp://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </a>- Victo=
rian
Curriculum and Assessment Authority and <br>
<a href=3D"ttp://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victo=
rian
Information Technology Teachers Association Inc<o:p></o:p></span></font></p>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confident=
ial. If received in error, please contact us and delete all copies. Before o=
pening or using attachments check them for viruses and defects. Regardless o=
f any loss, damage or consequence, whether caused by the negligence of the s=
ender 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, a=
nd not necessarily those of the Department of Education.</p></body>
</html>