+ Reply to Thread
Results 1 to 3 of 3

Using Excel formula in Access

  1. #1
    Registered User
    Join Date
    02-19-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Using Excel formula in Access

    Dear Colleagues,

    Please reply ASAP on this as it is hindering my work:

    I have simple excel formula I wish to use inside an access update query. However Access does not speak the same language as excel and I need to convert the formula below to ensure that it works in Access.

    The Excel formula are :

    =SUBSTITUTE(J70," ","")

    =RIGHT(J70,4)

    =LEFT(L70,2)

    =LEFT(L70,LEN(L70)-4)

    =RIGHT(P70,LEN(P70)-2)

    Thanks,
    Pav.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Using Excel formula in Access

    This is a free site, members answer as & when they have time, not because you are in a hurry!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,161

    Re: Using Excel formula in Access

    Look at this site and the functions, Left, Right, Len and Replace

    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1