[Year 12 IT Apps] Re: Access Help Please!!!

[tony at star.melb.catholic.edu.au]

Keith,

I believe you're after the Datediff function. It works well (see 1st link)....
but it has a hitch (see 2nd link) with a 'work around'.

http://office.microsoft.com/en-us/access/HA010550711033.aspx

http://www.fabalou.com/Access/Modules/datediff.asp

Hope this helps.

Cheers,
TJ

_______________________________________
This email and any attachments may be
confidential and, if you are not the intended
recipient, you must not disclose or use the
information in this mail.  If received in error,
please notify us immediately and delete the
email and all copies.

The college does not guarantee that this email
is virus free or error free. Any attached files are
provided and may 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 Star of the Sea College Inc. 


-- 
This email and any attachments may be confidential and, if you are not the
intended recipient, you must not disclose or use the information in this
mail. If received in error, please notify us immediately and delete the
Email and all copies. The school does not guarantee that this Email is virus
free or error free. The attached files are provided and may 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 Star of the Sea
College.