imposing an age constraint in access database

[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

 

[John Spencer]

Use a validation rule like the following on the DOB field

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

 

[MOOSH]

thanx JS, that is just perfect. much appreciated

Use a validation rule like the following on the DOB field

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

hi
can anyone help please

[quoted text clipped - 7 lines]

thanx