age constraint

M

MOOSH

hi
can any one assist me in a formula to calculate the age of kids eligible for
a paper round.
the kids need to be 14 or over and not a day under.
also where would i put this formula so that under age kids are not allowed to
be entered?
 
J

John Spencer

Answered in your other thread in forms coding.

Set the Validation Rule on the control in the form (or on the field in the
table) to

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