[Year 12 IT Apps] Access question

[McDonald, Debra A1]

are you requesting the result of a mode question?
 
you should be able to ask it to gather the mode(or access equivalent)  of th=
at field and as in maths it should come back with the name that occured the=
 most. can not think of the code right now but if you want I can look into i=
t if you still need help.
 
cheers
Debra McDonald
Network Manager
Lyndhurst Secondary College
Cranbourne
(03) 5996 0144

________________________________

From: itapps-bounces at edulists.com.au on behalf of Jones, Mark A
Sent: Tue 13/03/07 2:14 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 o=
f names then provide the name of the most numerous one. Any ideas would be a=
ppreciated.
 
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, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.

_______________________________________________ 
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority a=
nd 
http://www.vitta.org.au - VITTA Victorian Information Technology Teachers As=
sociation Inc

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, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5506 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070313/38c7bdf5/attachment-0001.bin