I have Access 2003 - What I am trying to do is pull out anyone who is at a certain age when a proceudre was done. For example: jane Doe was 17 on this date. I have the birthdate and the date of service.
I am using this is the query AgeAtProcedure: (DateDiff("yyyy",[PatientBirthDate],[FromDate]))
It is returnign the age as example - born 10-22-89 and date of service of 10-1-1989 as 18 - I want it to be 17 because at 10-1-1989 they are still 17. I don't want it to show 18 until 10-22-2007.