[Year 12 IT Apps] An access query question...

Tue Feb 19 19:31:31 EST 2008

WARNING: This e-mail has been altered by MIMEDefang.  Following this
paragraph are indications of the actual changes made.  For more
information about your site's MIMEDefang policy, contact
Mail Administrator <postmaster at edulists.com.au>.  For more information about MIMEDefang, see:

            http://www.roaringpenguin.com/mimedefang/enduser.php3

An attachment named Age.mdb was removed from this document as it
constituted a security hazard.  If you require this document, please contact
the sender and arrange an alternate means of receiving it.

-------------- next part --------------
Try this sample - I've done it within a query and within a report.

Hope this helps ... It's all in the brackets!

Regards,

Martin

(Warrandyte High School)
----- Original Message ----- 
From: "Timmer-Arends" <timmer at melbpc.org.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Tuesday, February 19, 2008 5:27 PM
Subject: Re: [Year 12 IT Apps] An access query question...

> Hello Kent
>
> if you've done something like [date1] - [date2] where these are fields, or 
> a field and a control, then Access will give you an answer in days. You 
> have to then convert the days into years (if that's what you want the 
> answer to be in).
>
> I can't remember if Access gives you a function to do this, but if not you 
> can write your own in 'modules' and just reference it in the query; eg 
> Days2Age([date1] - [date2]). Just remember to declare the function as 
> 'public'.
>
> 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: Tuesday, February 19, 2008 4:31 PM
> Subject: [Year 12 IT Apps] An access query question...
>
>
>> Ok folks, can I seek your help please about an on topic question?
>> Currently working through a sample database which many are probably 
>> familiar with. The Simco sample task.
>> My problem is that I am struggling to get from a query the 'Age' figure. 
>> ie DOB subtracted from current year via a query is the method I've tried. 
>> Used the method from the Microsoft help site but that uses a 
>> form...great, but not quite what I need and yes, I got that one to work.
>>
>> I have set up a table with DOB of the type date/time using 'short date' 
>> but just cant quite get a query to calculate an age using the above info.
>>
>> Would it be simpler if I just added a column to my tables and tried via a 
>> validation statement although having tried that without success I am 
>> beginning to wonder..
>>
>> Ok..so I aint no genius...I know what I am trying to do...just falling a 
>> little short here..
>>
>> Any ideas folks?
>>
>> HOWS ZAT?  Completely ON TOPIC...woohooo..
>>
>> 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 Bane, Janet A
>> Sent: Tue 2/19/2008 3:17 PM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: RE: [Year 12 IT Apps] problems with access switchboard
>>
>>
>> Thanks so much Nick and Richard.  This is why I love this list!
>>
>> Janet Bane
>> Patterson River SC
>>
>> ________________________________
>>
>> From: itapps-bounces at edulists.com.au on behalf of Lumsden, Richard G
>> Sent: Tue 19-Feb-08 1:09 PM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: RE: [Year 12 IT Apps] problems with access switchboard
>>
>>
>>
>> This happens when the Kids (logically) use cut and paste from the first 
>> button they draw on the form.
>>
>> Each Button must be drawn separately and named accordingly to prevent 
>> this type of problem
>>
>>
>>
>> ________________________________
>>
>> From: itapps-bounces at edulists.com.au 
>> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Bane, Janet A
>> Sent: Tuesday, 19 February 2008 12:22 PM
>> To: ITA List
>> Subject: [Year 12 IT Apps] problems with access switchboard
>>
>>
>>
>> Hi,
>>
>>
>>
>> we are doing Access at the moment and some kids are having problems with 
>> the switchboard form.
>>
>>
>>
>> We know how to do it, it just seems that one minute the buttons are 
>> working, and the next minute we get all sorts of error messages.  The 
>> messages are not helpful in explaining what the problem is.  In fact they 
>> make no sense at all, from what I can see. However, some kids sail 
>> through the switchboard without a problem, and they are following the 
>> exact same procedure.
>>
>>
>>
>> I am not strong in Visual basic, but the error messages seem to relate to 
>> a problem when the click event occurs.  It seems to think all the buttons 
>> are the same (or have an ambiguous name) even when they are linked to 
>> different reports and forms (and the button names are all different and 
>> appear to me to be quite sensible).  Is there a limit on the length of 
>> the button name or some protocol I am not following?
>>
>>
>>
>> Is there some trick to preventing this, or is it just "Access being 
>> difficult"???? Any suggestions greatfully received.
>>
>>
>>
>> regards,
>>
>>
>>
>> Janet Bane
>> Patterson River SC
>>
>> 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 and Early Childhood Development.
>>
>> _______________________________________________
>> 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%20> 
>>  - 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 and Early Childhood Development.
>>
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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 