Hi Rex,
I think the best approach is to use the DateDiff function in your query. For
example:
DateDiff("yyyy", [BirthDate], Now())
There are several different options for the first argument. Strangely for
years it is "yyyy" not a single "y".
The value returned by the function is a Long Integer.
regards,
Graeme
----- Original Message -----
From: "Rex Boggs" <[email protected]>
To: "QSITE ICT Teachers" <[email protected]>
Sent: Tuesday, August 10, 2010 4:57 AM
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=705616.699586d63200cea604d6cdff7a158cb4&n=T&l=qsiteict&o=1730043
or send a blank email to
leave-1730043-705616.699586d63200cea604d6cdff7a158...@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=1730357
or send a blank email to
leave-1730357-705742.d42ea647e85be3beb25392eea1a77...@edna.edu.au
