General discussion

Locked

Calculate Age with Access 2002

By dlb1 ·
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

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Calculate Age with Access 2002

by DKlippert In reply to Calculate Age with Access ...

Look for Date Time in the Table of Contents at this site:
http://www.mvps.org/access/tocurl.htm

Collapse -

Calculate Age with Access 2002

by dlb1 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

Calculate Age with Access 2002

by rapidad In reply to Calculate Age with Access ...

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

Collapse -

Calculate Age with Access 2002

by dlb1 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

Calculate Age with Access 2002

by john_wills In reply to Calculate Age with Access ...

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))

Collapse -

Calculate Age with Access 2002

by dlb1 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

Calculate Age with Access 2002

by john_wills In reply to Calculate Age with Access ...

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))

Collapse -

Calculate Age with Access 2002

by dlb1 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

Calculate Age with Access 2002

by dlb1 In reply to Calculate Age with Access ...

This question was auto closed due to inactivity

Back to Web Development Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums