how to use yearfrac in access database query

[mushmoom]

Hi

I tried using yearfrac function but it did not work there must be a way or function to get result in access query help please.

Thanks in Advance

Mushmoom

 

[james_lankford]

can you use the datediff function ?
http://www.techonthenet.com/access/functions/date/datediff.php

 

[mushmoom]

Thanks James

it work this is what i used

Age: Int(DateDiff('Y',[date of birth],[date])/365)