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

Wed Feb 20 10:13:09 EST 2008

Hi Kent,

Try this in the query

Age: DateDiff("yyyy",[DOB],Now())

Regards

Julie

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Kent Beveridge
Sent: Tuesday, 19 February 2008 4:32 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: 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 

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20080220/4b2b7323/attachment-0001.html