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

[Laurie Savage]

I think you will need an extra table - "Cohort" which simply has two
fields "Age" "Cohort" and the following rows of data
10 Junior
11 Junior
12 Junior
13 Intermediate etc 

OR

simply have three rows and put the upper age range into the "Age" field
and include a "less than or equal to Age" in your query.

Laurie

On Tue, Feb 27, 2007 at 11:12:54AM +1100, Keith Richardson mentioned:
> 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