[Year 12 IT Apps] Access qn..

Thu Feb 21 11:28:10 EST 2008

Kent,
If you can do the calculation , then so can access. !

Jock

On 21/2/08 10:05 AM, "Kent Beveridge" <kbeveridge at stbc.vic.edu.au> wrote:

> Nope, Damien I reckon you've just about covered it!
>  
> Your option 3 is the one I originally used courtesy of the microsoft help
> site..and it works fine for all the random dates I tried.
>  
> Ok folks...who's got the next curly question...(what about the percentage
> weight gain on the same sample OC, how'd we go with that one? )
> Handpass....
>  
>  
> Kent.
>  
> Kent Beveridge,
> I.T. co-ordinator
> St. Brigids Catholic Sec. College
> Horsham
> email.. kbeveridge at stbc.vic.edu.au
>  
> |<3|\|7  b3\/3r1D93 ?  ;-)
> Wishes and Eggs, one you make and one you break!  A bit like promises.....
> ³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 School does not guarantee that this email is
> virus or error free.  The attached files are provided and my 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 School.²
> 
> 
> From: itapps-bounces at edulists.com.au on behalf of ATKINSON-BUCK, Damien
> Sent: Wed 2/20/2008 3:53 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: RE: [Year 12 IT Apps] Access qn..
> 
> Hi all,
>         There have been several solutions to this problem and being slightly
> pedantic I tried them all. Basically they were (and apologies if I missed any
> others)
> Age1: Int((Now()-[DOB])/365.25)
> Age2: DateDiff("yyyy",[Dob],Now())
> Age3: 
> DateDiff("yyyy",[dob],Now())+Int(Format(Now(),"mmdd")<Format([dob],"mmdd"))
> 
> I got a little confused when Age2 came up with different results than Age1 &
> Age3 for all months except Feb. My guess is that without the formatting rules
> in 3 DateDiff only looks at what you specifically want it to, ie just the year
> in 2
> Does anyone have a better explanation of why this occurs?
> Damien Atkinson-Buck
> IT/Multimedia Teacher
> Ivanhoe Grammar School
> The Ridgeway, Ivanhoe, Victoria 3079 Australia
> Telephone +61 3 9490 3848 Facsimile +61 3 9497 4060
> mailto:damien.atkinson at igs.vic.edu.au
> http://www.igs.vic.edu.au <http://www.igs.vic.edu.au/>
>  
> 
>  
> Established in 1915, Ivanhoe Grammar School is a multi-campus, co-educational
> independent Anglican school with a proud tradition of academic, sporting and
> personal success. Buckley House caters for students from Early Learning to
> Year 6 and The Ridgeway Secondary Campus provides a unique 'pathway' for boys
> and girls from Years 7 to 10 and a fully co-educational setting in Years 11
> and 12 to study either the International Baccalaureate (IB) or Victorian
> Certificate of Education (VCE). The Plenty Campus at Mernda (30 kms north of
> Melbourne's CBD) is co-educational from Prep to Year 12. Ivanhoe Grammar
> School is a member of the Round Square international network of schools.
>  
> 
> 
> 
> -----Original Message-----
> From: Pamela Wright [mailto:P.Wright at latrobe.edu.au]
> Sent: Wednesday, 20 February 2008 3:08 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: RE: [Year 12 IT Apps] Access qn..
> 
> Hi Kent,
> I've had a go and have managed to do something quickly in query. I've zipped
> and attached. Hope it helps.
> 
> Pam
> Pam Wright
> Lecturer ICT
> Faculty of Education
> La Trobe University
> 
> -----Original Message-----
> From: Kent Beveridge [mailto:kbeveridge at stbc.vic.edu.au]
> Sent: Wednesday, 20 February 2008 12:43 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: RE: [Year 12 IT Apps] Access qn..
> 
> Thanks for all the ideas folks.
> The common approach seems to be via a 'form'...that one works well in its
> varying flavours as suggested on the list. And yes, I did get the 'form'
> version working even before I put the qn on the list.
> Unfortunately, what I cant get to work is (if you can picture this...)...
> A column in a table is headed DOB
> Another column in the same table is headed AGE Data from the sample database
> sheet is entered which includes DOB field for all the records.
> My so far unsuccessful attempts are to try to get the database to
> 'automatically calculate' the AGE, given the data in the DOB field via the
> table.
> I guess that since I also tried, again unsuccessfully, this via a query, that
> is why most of the suggestions are query or form based.
> 
> I must be holding my jaw wrong!
> 
> But I aint giving up just yet..(knew there was a reason computers annoy me!).
> 
> Kent.
> 
> Kent Beveridge,
> I.T. co-ordinator
> St. Brigids Catholic Sec. College
> Horsham
> email.. kbeveridge at stbc.vic.edu.au
> 
> |<3|\|7  b3\/3r1D93 ?  ;-)
> 
> Wishes and Eggs, one you make and one you break!  A bit like promises.....
> "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 School does not guarantee that this email is
> virus or error free.  The attached files are provided and my 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 School."
> 
> ________________________________
> 
> From: itapps-bounces at edulists.com.au on behalf of Hammond Kerrie
> Sent: Wed 2/20/2008 11:01 AM
> To: itapps at edulists.com.au
> Subject: [Year 12 IT Apps] (no subject)
> 
> 
> Hello folks
> 
> 
> I was wondering if someone could forward me the SIMCO access example that
> people have been referring to. I am new to teaching ITapps this year and would
> be very appreciative of this or any other relevant examples that I could use
> with my students.
> 
> As a "silent" observer to the list I would like to thank the regular
> contributors who are so generous with their resources and expertise.
> 
> Many thanks
> Kerrie Hammond
> Trinity College Colac
> 
> _______________________________________________
> http://www.edulists.com.au <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/vce/studies/infotech/infotechindex.html
> <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html>
> - 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
> _______________________________________________
> 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/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and http://www.vitta.org.au
> <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers
> Association Inc
> 
> 
> Privacy, Virus and Copyright Warning
> 
> The information contained in this electronic message (e-mail), and any files
> transmitted with it:
> 
> * is intended for the named recipients only. If you have received this in
> error, please advise the sender and delete it and any copies immediately;
> * Any personal information in this email must be used in accordance with the
> Privacy Act 1988 and this always applies even if it has been sent to you in
> error.
> * represents the views of the sender and does not necessarily represent the
> views or formal advice of Ivanhoe Grammar School;
> * may be subject to Copyright, so no further use should be made of it without
> the author's permission.
> 
> The School does not represent or warrant that the email or any files attached
> do not contain errors or are free from computer viruses or other defects nor
> does it accept responsibility for any loss or damage resulting directly or
> indirectly from the use of the email or any attached files.
> 
> 
> _______________________________________________
> 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/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian
> Information Technology Teachers Association Inc
> 
> 

Cheers,

Jock
__________________________
Jock Garnsworthy
Pasco St. 
Williamstown High School
(03)93971899

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 Williamstown High School.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20080221/5a8c0c69/attachment.html