Access 2000

[Silver Fox]

I want to determine current age of a person in my data
base. I have gone to Design View, properties, and entered
into "Control Source" the following: =Date()-
[BirthDate]. The result is a number that must be a Julian
calendar number. If I divide that number by 365, I get
the proper age. However, if I enter/365 after the above
expression, I get something like date & time....nothing
like I expected. Can you assist me in completing the
expression properly?

 

[Van T. Dinh]

See The Access We article:

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

HTH
Van T. Dinh
MVP (Access)