If all you want to do is determine whether or not they're currently 16,
determine what date was exactly 16 years ago, and see whether or not they
were born before that.
To determine the date exactly 16 years previous to today, you can use either
DateAdd("yyyy", -16, Date()) or DateSerial(Year(Date()) - 16, Month(Date()),
Day(Date()))
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
"Hannah" <(E-Mail Removed)> wrote in message
news:039301c38040$3c3b08f0$(E-Mail Removed)...
> I am trying to use a validation rule where if they have
> to be at least 16 years old. I do not know how to use
> the date(). It's for one of my classes, can someone help?
>
> Thanks
> Hannah