calculating age - still more help!

[suzzieo]

thank all of you for responding to helping me calculate age - however! I set up the calculation in my query using

Age: DateDiff("yyyy", [DOB], Date()) + (Date() < DateSerial(Year(Date()), Month([DOB]), Day([DOB])))

and it works beautifully but how do I get that calculated age to appear on the form?

thanks

 

[The_Doc_Man]

If [DOB] is a field in the record, create an unbound text box. Put that formula as the .ControlSource of the text box.