YearFrac

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?
 
M

[MVP] S.Clark

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/
 
Top