Try:
Year(Now) - Year_Birth + (DateSerial(Year(Now), Month_Birth, Day_Birth) > Now) ----- Original Message ----- From: "abdul daulay" <[email protected]> To: [email protected] Sent: Thursday, May 28, 2009 1:15:38 AM GMT -05:00 US/Canada Eastern Subject: [Access VBA Central] how to calculate between two dates I want to make a school database, but I don't know how to get a student age. I have three field name=Day_Birth, Month_Birth and Year_Birth. Please help me... [Non-text portions of this message have been removed]
