Rod, this is one tha we use in a query to calculate the current age
in whole years
Int(DateDiff("yyyy",[DOB],Date())) AS Age
Brett
At 15:15 18/10/05, you wrote:
>I have a database that I have created for a class activity. What I want
>to do is claculate the age of the student.
>
>IE: the file looks as todays date - the date of birth and then
>multiplies by 365.25 (This is what I have used in a spreadsheet
>program).
>
>I have created a field for the DOB and text box to do the calculation
>but can not work out how to perform the calculation.
>
>Any assistance appreciated.
>
>Regards Rod
>
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.344 / Virus Database: 267.12.1/135 - Release Date: 15/10/05
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.12.1/135 - Release Date: 15/10/05
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
