age constraint

  • Thread starter Thread starter MOOSH
  • Start date Start date
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?
 
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())
 
Back
Top