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

[Tony Beggs]

Keith
I would be interested in this one also
Currently I transport the total member file into Excel, run a multiple IF statement over the lot and then return the new data at the start of the season into the Access DBMS.
Tony
St Patrick's College Ballarat
 

________________________________

From: itapps-bounces at edulists.com.au on behalf of Keith Richardson
Sent: Tue 27/02/2007 11:12 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 <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/>  - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 4572 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070227/1be41ebf/attachment.bin