Q Queent Jan 23, 2006 #1 I need some help, can anyone tell me how to do a calculation in access to show person must be 14 years and over
I need some help, can anyone tell me how to do a calculation in access to show person must be 14 years and over
A Allen Browne Jan 23, 2006 #2 How about a query, and in the Criteria row under the BirthDate field, enter: <= DateAdd("yyyy", -14, Date())
How about a query, and in the Criteria row under the BirthDate field, enter: <= DateAdd("yyyy", -14, Date())