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=705742.d42ea647e85be3beb25392eea1a77f09&n=T&l=qsiteict&o=1730045
or send a blank email to
leave-1730045-705742.d42ea647e85be3beb25392eea1a77...@edna.edu.au
