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