If the results are showing negative, then reverse the 2 dates
DateDiff("yyyy",DOB,Now())
but as Allan said, his Age function is accurate right to the day.
Moderator
Windows XP 
Access 2003
If the results are showing negative, then reverse the 2 dates
DateDiff("yyyy",DOB,Now())
but as Allan said, his Age function is accurate right to the day.
Posting Permissions
Reply With Quote