I would like to calculate an age based on a a particular point in a year. For little league, your age as of April 30th is used to determine how old you are for the entire year. So someone born 3/5/2004 is considered 9, will some born 5/5/2004 is considered 8. I can do this in Excel using =DATEDIF(A1,"5/1/" & YEAR(NOW()),"y"). That works great. My problem is access doesn't recognize DATEDIF. I have a text box called txtDOB which holds the birthday. I am trying to enter into the control source of a text box on a form. any ideas?