[Year 12 IT Apps] Access qn..

[Timmer-Arends]

Hello again Kent
If I understand you correctly you have a dob field in a table containing 
dob's, and an age field contain blanks, and you want to fill the age field 
with the age based on the dob. In that case the various suggestions using a 
query need to be extended by making the field an update query and pointing 
the result of the datediff calc at the age field in the originating table. 
You must RUN the query and not just preview it for it to work..

Regards
Robert T-A
Brighton SC


----- Original Message ----- 
From: "Kent Beveridge" <kbeveridge at stbc.vic.edu.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Wednesday, February 20, 2008 12:42 PM
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