Results 1 to 2 of 2
  1. #1
    lmp101010 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2009
    Posts
    10

    excel function in access

    I am would like to use the YearFrac function in for an access query, however this is not available. I have tried adding the Excel object library in the VBA editor but it still won't allow me to use it. Any help?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    try the datediff() function. google is your friend for syntax and uses.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Load images in access using iif function?
    By sureshfina in forum Forms
    Replies: 1
    Last Post: 12-22-2009, 11:05 AM
  2. Access SQL Query - Aggregate function
    By jack in forum Access
    Replies: 0
    Last Post: 11-10-2009, 08:06 PM
  3. Replies: 1
    Last Post: 08-31-2009, 10:24 AM
  4. to_char function in Access?
    By Amber_1977 in forum Queries
    Replies: 0
    Last Post: 01-20-2009, 04:45 PM
  5. Excel Function PercentRank in MS Access ?
    By world33 in forum Programming
    Replies: 1
    Last Post: 10-27-2006, 07:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums