[Year 12 IT Apps] Access question

[Laurie Savage]

You could use a group query and from memory you could sort the result by
count(group).
 
Laurie

  _____  

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Jones, Mark A
Sent: Tuesday, 13 March 2007 2:15 PM
To: itapps at edulists.com.au
Subject: [Year 12 IT Apps] Access question


Dear all
 
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.
 
regards
Mark Jones
Cann River P-12 College

Important - 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.

_______________________________________________ 
http://www.edulists.com.au  <ttp://www.edulists.com.au> - FAQ, resources,
subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au  <ttp://www.vcaa.vic.edu.au> - Victorian
Curriculum and Assessment Authority and 
http://www.vitta.org.au  <ttp://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070313/f7608e31/attachment.html