Calculating age from birthdate

yuccakid

New member
Local time
Today, 08:37
Joined
Apr 28, 2000
Messages
9
I have a form based on a query. Two fields are DOB and Age. The Age field datatype in the underlying table is number. I use the following as the Control Source in the Age field:
=IIf(IsNull([DOB]),"",Year(Now())-(Year([DOB])-(DateSerial(Year(Now()),Month([DOB]),Day([DOB]))>Now())))
I cannot compile because of a "syntax" error.
Help!!!
 

Users who are viewing this thread

Back
Top Bottom