Undefined function "Left" (1 Viewer)

[digit]

I have that query
SELECT Polici.EGN_zastrahovasht, Left([EGN_zastrahovasht],2) AS Expr1
FROM Polici
GROUP BY Polici.EGN_zastrahovasht, Left([EGN_zastrahovasht],2);
but when im startin up the access says to me Undefined function "Left" in expression !!!
any suggestions?

 

[DJN]

This may have something to do with missing references. Click on the Modules tab in the dabase window. Open any module. Go to Tool ->References. make sure that there are no missing references, and make sure that the Microsoft DAO 3.5 object library is checked.


David