access query wont run.

Acces gives an error saying a field could refer to more than one table but they are all fully referenced i think so i cannot see why it fails:
q1uestions: [AbiCurrentcodes].[EngineTypediff]
i am trying to capture change events where the field enginetypediff has changed since last month.

SELECT QryClientDifferencesLogic.[abiCode], [AbiCurrentcodes].[EngineTypediff] AS CurrentT, [AbicodesPrevious].[EngineTypediff] AS PrevT, "2012-08" AS Expr1
FROM (QryClientDifferencesLogic LEFT JOIN AbicodesPrevious ON QryClientDifferencesLogic.abiCode = AbicodesPrevious.abiCode) LEFT JOIN Abicurrentcodes ON QryClientDifferencesLogic.abiCode = Abicurrentcodes.abiCode
WHERE (((QryClientDifferencesLogic.EngineTypediff)=-1));

Open in new window

PeterBaileyUkAsked:
Who is Participating?
 
Dale FyeCommented:
Take a look at qryClientDifferencesLogic and see if it has any duplicate field names.
0
 
xtermieCommented:
Try referencing each field with its table in all occurances.
Also put table names in brackets in all instances

SELECT [QryClientDifferencesLogic].[abiCode], [AbiCurrentcodes].[EngineTypediff] AS CurrentT, [AbicodesPrevious].[EngineTypediff] AS PrevT, "2012-08" AS Expr1
FROM (QryClientDifferencesLogic LEFT JOIN AbicodesPrevious ON [QryClientDifferencesLogic].[abiCode] = [AbicodesPrevious].[abiCode]) LEFT JOIN Abicurrentcodes ON [QryClientDifferencesLogic].[abiCode] = [Abicurrentcodes].[abiCode]
WHERE ((([QryClientDifferencesLogic].[EngineTypediff])=-1));
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.