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

Tue Feb 19 17:27:03 EST 2008

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 