[AccessD] Join expression not supported

Hi Chester

Maybe Well_Number is not a string?
Thus:
LEFT JOIN ConfigMaster ON Right([ConfigMaster].[PID],Len([ConfigMaster].[PID])-4))= CStr(dbo_DSS_CompletionMaster.Well_Number)

/gustav

>>> Chester_Kaup at kindermorgan.com 19-02-2007 18:30:05 >>>
I an getting a join expression not supported error from the following query. I am not seeing the problem. Thanks

SELECT dbo_DSS_CompletionMaster.PID, Right(ConfigMaster.PID,Len(ConfigMaster.PID)-4) AS WellName
FROM ConfigMaster, dbo_DSS_CompletionMaster
LEFT JOIN ConfigMaster ON Right([ConfigMaster].[PID],Len([ConfigMaster].[PID])-4))= dbo_DSS_CompletionMaster.Well_Number
WHERE (((ConfigMaster.PID) Like "PAT*") AND ((Right([ConfigMaster].[PID],Len([ConfigMaster].[PID])-4)) Not Like "*GAP") 
GROUP BY dbo_DSS_CompletionMaster.PID, Right(ConfigMaster.PID,Len(ConfigMaster.PID)-4);

Chester Kaup