How to calc age from birthdate?

[Restless Me]

Have Access 2000 running in XP.

This is probably very simple, but it has escaped me even though I've read
thru two text books and searched this site for similar problems.

Would like to display a members age in a report field based on today's date
and their birthdate. Can anyone help?

Thanks,

Cliff

 

[Cheryl Fischer]

Here is some code from The Access Web:

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

 

[Restless Me]

Thanks, Cheryl. This did the job.

Cliff
Here is some code from The Access Web:

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

 

[Luong]

Try this:
Age: Round((Date()-[DOB])/365)
DOB is the fieldname contains date of birth
This works in Access 2000.
Good luck!
Luong

 

[Douglas J. Steele]

The code samples Cheryl suggested at "The Access Web" are more reliable than
your suggestion, Luong.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Try this:
Age: Round((Date()-[DOB])/365)
DOB is the fieldname contains date of birth
This works in Access 2000.
Good luck!
Luong

-----Original Message-----
Here is some code from The Access Web:

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

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

based on today's
date


.