YearFrac

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

Excel has a function named YearFrac() which allows you to
specify where a year calculation uses 365 or 360 days. I
would like to use this in Access, however, when I include
it in a query it tells me it is undefined. It is listed
in the help screen. Can I get this function to work in
Access?
 
If you set a reference to the Excel Library, you should be able to use it.

Open any module
Choose Tools / References from the Menu
Scroll to find anything that starts with "Microsoft Excel" and check it

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.fmsinc.com/consulting/
 
Back
Top