Age: (Now()-[Birthdate])/365.25 That will take leap years into account and give the students a 'formula' for more accurately working out the age of things much older than even mothers in law.
Regards, Darren >>> "paul" <[email protected]> 08/10/10 6:13 AM >>> 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 > > > > --- > You are currently subscribed to qsiteict as: [email protected]. > To unsubscribe click here: > http://lyris.edna.edu.au/u?id=705949.9a10fb3d2e82589ca7ebb66775cc8495&n=T&l=qsiteict&o=1730043 > or send a blank email to > leave-1730043-705949.9a10fb3d2e82589ca7ebb66775cc8...@edna.edu.au --- You are currently subscribed to qsiteict as: [email protected]. To unsubscribe click here: http://lyris.edna.edu.au/u?id=705918.6847047ae1ecff960e447841b6ae3a2b&n=T&l=qsiteict&o=1730045 or send a blank email to leave-1730045-705918.6847047ae1ecff960e447841b6ae3...@edna.edu.au --- 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=1730107 or send a blank email to leave-1730107-705742.d42ea647e85be3beb25392eea1a77...@edna.edu.au
