ODBC Call Failed Error for Query using Linked Tables

[imnewtoaccess]

Hi,

SELECT TK_TURN_DAILY_DETAIL1.DATE, TK_TURN_DAILY_DETAIL1.USH_REVENUE AS TDL_Revenue, TK_TCK_SALE_DETAILS1.USH_REVENUE AS TSD_Revenue, [TSD_Revenue]-[TDL_Revenue] AS Expr1, TK_TCK_SALE_DETAILS1.TK_SERIAL AS TSD_TK_SERIAL, TK_TURN_DAILY_DETAIL1.TK_SERIAL AS TDL_TK_SERIAL, TK_TCK_SALE_DETAILS1.QTY_TIX_REP AS TSD_Quantity, TK_TURN_DAILY_DETAIL1.TCK_SCAN_QTY AS TDL_Quantity
FROM TK_TCK_SALE_DETAILS1 RIGHT JOIN (TK_TURN_DAILY_DETAIL1 INNER JOIN TK_IMPORT_TICKET1 ON TK_TURN_DAILY_DETAIL1.TK_SERIAL = TK_IMPORT_TICKET1.TK_SERIAL_EXTERNAL) ON TK_TCK_SALE_DETAILS1.TK_SERIAL = TK_IMPORT_TICKET1.TK_SERIAL_INTERNAL
WHERE (((TK_TURN_DAILY_DETAIL1.DATE)=[VARIANCE_DATE]) )
ORDER BY TK_TURN_DAILY_DETAIL1.DATE;

When I run this query from MS Access, I get an 'ODBC Call Failed' error. I have created linked tables in access for the tables used in this query.

Anybody able to help me on this ?

Thanks in Advance.

[NeoPa]

It's almost certainly nothing to do with your query (SQL) per se.
This is an ODBC problem. This is as varied as there are ODBC drivers out there, but I'd start by trying to open each of the tables in your query to see which of them has a problem. From there it's down to whoever at your company is responsible for the ODBC setup I'm afraid.