Hello,
I'm working on Windows Vista Business (32bit) and MS Access 2010.
I'm currently working on a form, and on this form i have many fields. 2 of these fields are DateOfBirth and Age. The DateOfBirth field comes just before the Age field. I'm trying to get the Age field automatically populated as soon as a person fills out the DateOfBirth field. I have tried using the following code in the [Default Value] and it hasn't worked:
=DateDiff("yyyy",[DateOfBirth],Date())-IIf(Format([DateOfBirth],"mmdd")>Format(Date(),"mmdd"),1,0)
I would appreciate any assistance i get from you all.