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

[Keith Richardson]

Thank you Litsa - unfortunately I got this message instead of your
attachment:

"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.

_______________________________________________
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
"

Perhaps if you zipped it ti might get through?
Cheers, Keith

On Tue, 27 Feb 2007 12:28:56 +1100, "Litsa Tzelepis"
<htzelepis at msj.melb.catholic.edu.au> said:
> 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.
> 
Keith Richardson
ITA List Moderator
Head of ICT, Leibler Yavneh College
Elsternwick
Ph: 03.9528.4911
k.richardson at yavneh.vic.edu.au