K
Ken
I am converting an access 97 database to access 2000.
A few error warnings came up during the conversion, but I got round them
with the exception of a text field.
The text field shows the age of someone.
It looks at the Date of Birth field [D-O-B] and compares it to today's date
then displays the result as an integer.
The formula in Access 97 is
=DateDiff("yyyy",[D-O-B],Date())-IIf(Date()<DateSerial(Year(Date()),Month([D
-O-B]),Day([D-O-B])),1,0)
This was given to me about 5 years ago from an access news group.
In access2000 the text box shows #Name?
Can anyone help with correct formula for 2000..
Regards
Ken
A few error warnings came up during the conversion, but I got round them
with the exception of a text field.
The text field shows the age of someone.
It looks at the Date of Birth field [D-O-B] and compares it to today's date
then displays the result as an integer.
The formula in Access 97 is
=DateDiff("yyyy",[D-O-B],Date())-IIf(Date()<DateSerial(Year(Date()),Month([D
-O-B]),Day([D-O-B])),1,0)
This was given to me about 5 years ago from an access news group.
In access2000 the text box shows #Name?
Can anyone help with correct formula for 2000..
Regards
Ken