YEARFRAC Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
In Excel, there is YEARFRAC function which calculates the difference between
the two given dates in year, including all decimals, set by the user. I
tried to use the same function in Access query, but did not work. I want to
get to the decimal point. Is there any function that does the same work as
YEARFRAC?
Thanks,
 
Seong

If you must use the YEARFRAC function in Access, you can set a reference to
Excel and "borrow" the function from there.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top