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

[Litsa Tzelepis]

WARNING: This e-mail has been altered by MIMEDefang.  Following this
paragraph are indications of the actual changes made.  For more
information about your site's MIMEDefang policy, contact
Mail Administrator <postmaster at edulists.com.au>.  For more information about MIMEDefang, see:

            http://www.roaringpenguin.com/mimedefang/enduser.php3

An attachment named age.mdb was removed from this document as it
constituted a security hazard.  If you require this document, please contact
the sender and arrange an alternate means of receiving it.

-------------- next part --------------
here is a little sample, i hope its what you're looking for.
you will need an imbedded if statement i'd imagine, to slot them into the
right age bracket.

go into the query design to see the formula for the age

litsa tzelepis




----- Original Message ----- 
From: "Keith Richardson" <keithcr at fastmail.fm>
To: "List IP&M" <ipm at edulists.com.au>
Sent: Tuesday, February 27, 2007 11:12 AM
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
>
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.