How do I fix a join expression error?

N

nikki

When i try to open a query, i get this message: ... Access can't represent
the join expression...etc. Here is the sql view:
SELECT ShowBidAward.NAME, ShowBidAward.PERM_JTITL_DESC_DX AS [Present Job
Title], All_associates.WORK_ADDRESS1_NX AS [Present Work Address],
All_associates.UNION_LOC_DESC_DX AS [Union Local],
JobInTitle_1stPreference.[ListOnePositionAtATimeIncludingAwarded.Rate Date],
All_associates.SERVICE_DT AS [Service Date], [No Tests Needed].[Tests
Needed], JobInTitle_1stPreference.FirstPreference,
JobInTitle_1stPreference.titlematch, ShowBidAward.Title,
ShowBidAward.PostingListTag, ShowBidAward.Qty, ShowBidAward.Tour,
ShowBidAward.City, ShowBidAward.State, JobInTitle_1stPreference.Awardedthisbid
FROM ((ShowBidAward LEFT JOIN [No Tests Needed] ON ShowBidAward.SSN=[No
Tests Needed].ssn) INNER JOIN All_associates ON
ShowBidAward.EMPLID=All_associates.EMPLID) INNER JOIN
JobInTitle_1stPreference ON
ShowBidAward.NAME=JobInTitle_1stPreference.[ShowBidAward].NAME
ORDER BY JobInTitle_1stPreference.FirstPreference,
JobInTitle_1stPreference.titlematch;
I'm stuck, any help would be great, thanks
 
B

bcap

It isn't saying that there's anything wrong with the join, simply that it
cannot figure out how to display it in the graphical Query Designer. No
problem, just work on it in the SQL view.
 
J

John Spencer

FROM ((ShowBidAward LEFT JOIN [No Tests Needed] ON ShowBidAward.SSN=[No
Tests Needed].ssn) INNER JOIN All_associates ON
ShowBidAward.EMPLID=All_associates.EMPLID) INNER JOIN
JobInTitle_1stPreference

ON ShowBidAward.NAME=JobInTitle_1stPreference.[ShowBidAward].NAME

The last on clause appears to be suspect to me. I would suspect that it
should read:
ON ShowBidAward.NAME=JobInTitle_1stPreference.NAME


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Top