How to calculate ages in MS Access

[870 House, Birmingham UK]

How can I calculate current age from a date of birth - using "yearpart" etc
doesn't allow for leap years? Is there a function for this?

Many thanks for any help you can give.

 

[Andi Mayer]

How can I calculate current age from a date of birth - using "yearpart" etc
doesn't allow for leap years? Is there a function for this?

http://groups-beta.google.com/groups?hl=en&q=age+calculation+group:*Access*"&qt_s=Search+Groups

and choose one from the 520 hits

 

[Van T. Dinh]

See The Access Web:

http://www.mvps.org/access/datetime/date0001.htm

--
HTH
Van T. Dinh
MVP (Access)


<870 House>; "Birmingham UK" <870 House, Birmingham
[email protected]> wrote in message
news:[email protected]...

 

[John Vinson]

How can I calculate current age from a date of birth - using "yearpart" etc
doesn't allow for leap years? Is there a function for this?

Many thanks for any help you can give.

Or to save you searching...<g>

Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

John W. Vinson[MVP]

 

[Andi Mayer]

How can I calculate current age from a date of birth - using "yearpart" etc
doesn't allow for leap years? Is there a function for this?

Many thanks for any help you can give.

Or to save you searching...<g>

Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

this gives you 147 hits

 

[John Vinson]

this gives you 147 hits

lots of them mine... <g>

John W. Vinson[MVP]

 

[Andi Mayer]

lots of them mine... <g>

I know, but the beta doesn't allow you to filter for group and author
or
I am to stupid?

 

[John Vinson]

I know, but the beta doesn't allow you to filter for group and author
or
I am to stupid?

It's Google Groups Beta that's stupid!


John W. Vinson[MVP]

 

[Andi Mayer]

It's Google Groups Beta that's stupid!

Thank you, you made my Day ;-)