Rex, http://www.pcreview.co.uk/forums/thread-1158252.php or http://www.mvps.org/access/datetime/date0001.htm probably provide what you need.
ken > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of paul > Sent: Tuesday, 10 August 2010 6:06 AM > To: QSITE ICT Teachers > Subject: Re: [qsiteict] Access query to calculate age? > > Rex > may be rough and ready, but would this work: > Age: (Now()-[Birthdate])/365 > > where birthdate is an actual field. > > Hope it's of some use. > > Paul > > -------------------------------------------------- > From: "Rex Boggs" <[email protected]> > Sent: Tuesday, August 10, 2010 4:57 AM > To: "QSITE ICT Teachers" <[email protected]> > Subject: [qsiteict] Access query to calculate age? > > > Does anyone know how to write an Access query or macro to calculate > > the age of a person (in years) from their birth date and > today's date? > > > > TIA for any help. > > > > Cheers > > > > Rex > > ----------------------------------------------------------------------------- CONFIDENTIALITY NOTICE AND DISCLAIMER Information in this transmission is intended only for the person(s) to whom it is addressed and may contain privileged and/or confidential information. If you are not the intended recipient, any disclosure, copying or dissemination of the information is unauthorised and you should delete/destroy all copies and notify the sender. No liability is accepted for any unauthorised use of the information contained in this transmission. This disclaimer has been automatically added. --- You are currently subscribed to qsiteict as: [email protected]. To unsubscribe click here: http://lyris.edna.edu.au/u?id=705742.d42ea647e85be3beb25392eea1a77f09&n=T&l=qsiteict&o=1730068 or send a blank email to leave-1730068-705742.d42ea647e85be3beb25392eea1a77...@edna.edu.au
