Web Development

Ask something
Discussion Locked

Calculate Age with Access 2002

0 helpful
9 replies

by dlb1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have attempted to calculate a persons age with the information provided by Mircosoft. However, it does not work or I am, most likely, doing something wrong.

I am hoping someone would be kind enough to email me a step by step instruction on this formula.

I am taking the dob, which is data entried, and after that it goes crazy or I go crazy...

Please help. If you could email your response I would greatly appreicate it.

Thank You.

Don Barkley
dlb1@cox.net

9 replies

by rapidad

Don, heres a little trick for you. take a tape measure and fold it back on its self till the start is at the current year (102"). the date of birth is now opposite the persons age. Enjoy

by john_wills

It is not clear to me what your problem is. However, recently a colleague of mine in the office was getting "#Name" as age. The reason was that the dates she was addressing with the function DateDiff were texts, not dates, because the expression wastaking them from the form, even though the form had them from the database. The solution was to put each control name in a call to DateValue, thus:
=DateDiff(DateValue(DOB),DateValue(ReferenceDate))

by john_wills

It is not clear to me what your problem is. However, recently a colleague of mine in the office was getting "#Name" as age. The reason was that the dates she was addressing with the function DateDiff were texts, not dates, because the expression wastaking them from the form, even though the form had them from the database. The solution was to put each control name in a call to DateValue, thus:
=DateDiff(DateValue(DOB),DateValue(ReferenceDate))

This discussion is closed to new replies.