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

Tue Feb 19 18:38:15 EST 2008

In a form insert a text box and type =int(now()-[D_O_B]/365.25) where D_O_B
is the Date Of Birth field in the table
In a spare column in a query type Age: int(now()-[D_O_B]/365.25)
Formulae also works in a spreadsheet substituting [D_O_B] with the relevant
cell reference.
Hope it helps

Jock

On 19/2/08 4:31 PM, "Kent Beveridge" <kbeveridge at stbc.vic.edu.au> wrote:

> 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
> 

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/20080219/beaa5ced/attachment-0001.html