Right() function not working

[Adam]

Hi All,

I have a make-table query which, in one field, takes the right most 6
characters of one table field.

Unfortunately when I try to run the query it says "Undefined function
'Right' in expression."

Any idea's?

PS - The table is a SQL server table which is linked.

See below the query in SQL format:

SELECT Right([dbo_CALL_HDW]![CALLID_HDW],6) AS [Call Ref],
ConvertDate([CALLDAT_HDW]) AS [Call Date], dbo_CALL_HDW.STATUS_HDW,
dbo_CALL_HDW.CALLOPR_HDW, dbo_CALL_HDW.CATCAL1_HDW
FROM dbo_CALL_HDW
WHERE (((ConvertDate([CALLDAT_HDW]))>=#1/1/2005#) AND
((dbo_CALL_HDW.STATUS_HDW)="OPEN") AND
((dbo_CALL_HDW.CATCAL1_HDW)="SALES&GEN"));

 

[Brendan Reynolds]

This frequently indicates a missing or mis-matched reference. See Doug
Steele's article on the problem at the following URL ...

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html