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

Tue Mar 13 21:09:12 EST 2007

sorry Keith only just got your message  will check it out and email you in t=
he morning..

cheers

Deb

________________________________

From: itapps-bounces at edulists.com.au on behalf of Keith Richardson
Sent: Tue 27/02/07 1:01 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Access Help Please!!!

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 manuall=
y
> > 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, resourc=
es, subscribe, unsubscribe
> > IT Applications Mailing List kindly supported by
> > http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/>  - Victorian Cu=
rriculum and Assessment Authority and
> > http://www.vitta.org.au <http://www.vitta.org.au/>  - VITTA Victorian In=
formation 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/>  <http://www.edul=
ists.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/>  <http://www.vcaa=
.vic.edu.au/> - Victorian
> Curriculum and Assessment Authority and
> http://www.vitta.org.au <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 <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 Curr=
iculum and Assessment
> Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Inf=
ormation Technology
> Teachers Association Inc
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 Curric=
ulum and Assessment Authority and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Infor=
mation 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, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8240 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20070313/0283f1a2/attachment.bin