Search code examples
ms-access

Undefined function 'mid' in expression in MS Access

I am trying to write a query in MS Access, and receiving the error "Undefined function 'mid' in expression' when I try to execute it.

SELECT MID([ColumnName], 4,2)
FROM tblName

As I understand it, the MID function is the MS Access equivalent to Substring. Both the table and the column definitely exist. What could be causing this error?

Solution

  • Check 'References' in 'Tools' menu in VBA, there must be some 'MISSING' libraries.