[Year 12 IT Apps] Access Help Please!!!

[Lumsden, Richard G]

Is this what would help, Keith?

http://office.microsoft.com/en-au/access/HA010550711033.aspx?pid=3DCL10057
0041033

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Keith Richardson
Sent: Tuesday, 27 February 2007 11:13 AM
To: List IP&M
Subject: [Year 12 IT Apps] Access Help Please!!!

Hi all you Access Experts.
Three of us have a problem - how do we get Access to tell us which age
group an individual belongs to (Junior 10-12, Intermediate 13-14, Senior
14-18) starting with date of birth (an entered field in the members
table). We worked out how to create a query that would get current age
based on date-now and dob, then selection based on a particular age
range for criteria, but that simply gives me a list of member names who
fall into
that age group at any time. What I want to do is flow that information
into something that will flow into a report, without having to manually
look through the lists of names of members in a particular age group.
Hope that isn't too complicated!
Regards, Keith (for Keith, Henry & Diane)
Keith Richardson

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and
http://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.