Share via

Web Access 2013 Left Function not working

Anonymous
2015-09-30T20:56:07+00:00

In a select query I use the Left([String],number of characters) Function to return the left 9 characters in an 11 character field.  This functions normally with my desktop Access 2010.  I recently purchased Office 365 with Access and it does not work.  The returned "Unidentified function "Left" in expression.  I run the same database through the desktop Access 2010 and it runs the query fine.  Is this a code issue on Microsoft Access Web?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-10-01T16:39:50+00:00

    Tom, thanks so much for the reply.  There was a missing dynamic link in the database that Access 2013 (which is part of my version of Office 365) uses.  I went into Visual Basic, Tools, References and found the "Missing" available reference.  I unchecked the "Missing" which was an Web XP reference, closed the database and opened it again.  The "left([string],number) works.  Thanks for your help

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  2. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2015-10-01T03:50:42+00:00

    Can you provide more information? I used Home > Advanced > Query, selected the Customers table in my test database, and created the first field: Left9: Left([CustomerName],9)

    It worked just fine. What is different about your situation?

    Was this answer helpful?

    0 comments