[Year 12 IT Apps] Access question

[Lumsden, Richard G]

This sort of task could be done by use of a code.

 

This could be done by building an Event code module or a macro code.

Event code would require the use of recordsets and a function called
DCOUNT(XXX,XX,XXX)

There are standard example procedures given in the online help at
Microsoft.

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.

________________________________

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


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 --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070313/01173384/attachment.html