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

[Keith Richardson]

Thank you Debra. We are an independent schoool so do not use "Cases" -
so if it would be possible for U 2 send me the statement, that would be
great.
Cheers, Keith



On Tue, 27 Feb 2007 12:15:18 +1100, "McDonald, Debra A1"
<mcdonald.debra.a1 at edumail.vic.gov.au> said:
> hi Keith,
> 
> cases 21 the program that the admin computers has does this for you they
> have an automatic query with this built in.  so go ask them as they
> should be able to do it for you..  if not get back to me and I will get
> my office to send you the statement.
> 
> cheers
> Debra McDonald
> Network Manager
> Lyndhurst Secondary College
> Cranbourne
> (03) 5996 0144
> 
> ________________________________
> 
> From: itapps-bounces at edulists.com.au on behalf of Lesley Humphries
> Sent: Tue 27/02/07 12:00 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Access Help Please!!!
> 
> 
> Hi Keith,
> 
> I did something like this a few weeks ago, but can't find it now. It is a
> fairly complicated statement that you put in a query. I originally found
> it by just googling something like "access database convert date of birth
> to age" and found the answer almost straight away. I'm sorry I haven't
> still got it.
> 
> Lesley
> 
> > 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
> 
> 
> ___________________________________________________________
> Ms Lesley Humphries
> Learning Technologies Co-ordinator
> Santa Maria College
> 50 Separation Street
> Northcote 3070
> Ph: 9489 7644
> ___________________________________________________________
> This email and any attachments may be confidential. You must not disclose
> or use the information in this email if you are not the intended
> recipient. If you have received this email in error, please notify us
> immediately and delete the email and all copies. The College does not
> guarantee that this email is virus or error free. The attached files are
> provided and may only be used on the basis that the user assumes all
> responsibility for any loss, damage or consequence resulting directly or
> indirectly from the use of the attached files, whether caused by the
> negligence of the sender or not. The content and opinions in this email
> are not necessarily those of the College
> _______________________________________________
> 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
> 
> 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, damage or consequence, whether caused by the
> negligence of the sender or not, resulting directly or indirectly from
> the use of any attached files our liability is limited to resupplying any
> affected attachments. Any representations or opinions expressed are those
> of the individual sender, and not necessarily those of the Department of
> Education.
> _______________________________________________
> 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
Keith Richardson