imposing an age constraint in access database

M

MOOSH

hi
can anyone help please
i am creating a database for a newsagent. the delivery kids need to be 14
years old and over.
i need to impose an age constraint (where any kid too young will not be
allowed to be entered in the database) but don't know the formula or where to
put it. i have a table for the kids,one of the attributes is DOB.
any suggestions would be a great help.

thanx
 
J

John Spencer

Use a validation rule like the following on the DOB field

<DateAdd("yyyy",-14,Date())
 
Top