# Web Development

## General discussion

Locked

### Calculate Age with Access 2002

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

Thank You.

Don Barkley
dlb1@cox.net

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

### Calculate Age with Access 2002

by In reply to Calculate Age with Access ...

http://www.mvps.org/access/tocurl.htm

Collapse -

### Calculate Age with Access 2002

by In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

### Calculate Age with Access 2002

by 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 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

### Calculate Age with Access 2002

by 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 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

### Calculate Age with Access 2002

by 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 In reply to Calculate Age with Access ...

The question was auto-closed by TechRepublic

Collapse -

### Calculate Age with Access 2002

by In reply to Calculate Age with Access ...

This question was auto closed due to inactivity

## Related Discussions

• 12

• 23

• 2

inextures ·

• 10

#### Best software to design Simple Website?

matthewjohn938 ·

• 3

#### some one can make every type of website through wordpress development?Yes o

deltoraquest08 ·