[Year 12 IT Apps] Access qn..

ATKINSON-BUCK, Damien damien.atkinson at igs.vic.edu.au
Wed Feb 20 15:53:27 EST 2008


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
  

  
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/> - 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/> - VITTA Victorian Information Technology Teachers Association Inc _______________________________________________
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  - 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.




More information about the itapps mailing list