Syntax error with query on access

Question

    SELECT Surname, Firstname, Team_Name, PostCode, Winner, Date_Of_Game,
          Place_Of_GameFROM, tblPlayerProfile 
    INNER JOIN tblTeamDetails 
        ON tblPlayerProfile.Team_ID_Number = tblTeamDetails.Team_ID_Number 
    INNER JOIN tblMatchStatistics 
        ON tblTeamDetails.Team_ID_Number = tblMatchStatistics.Team_ID_Number
    INNER JOIN tblGameResults 
        ON tblMatchStatistics.MatchID = tblGameResults.MatchID
    WHERE (((tblGameResults.MatchID)=[FormsReport]![MatchFormReportD8]![Combo10]));

I'm having trouble

It's Access SQL. All joins past the first one need to be surrounded by `()`. — Marc B, Mar 12 '14 at 20:11
also you have no space before `FROM` `Place_Of_GameFROM tblPlayerProfile` --> `Place_Of_Game FROM tblPlayerProfile` — Brad, Mar 12 '14 at 20:12

JohnnyAW · Accepted Answer · 2014-03-12T22:14:07.900

1

Place_Of_GameFROM tblPlayerProfile -> Place_Of_Game FROM tblPlayerProfile

edited Mar 12 '14 at 22:14

answered Mar 12 '14 at 20:12

JohnnyAW

2,766
1
13
26

score 0 · Answer 2 · answered Mar 12 '14 at 20:18

Check out this query. You forgot to specify FROM.

SELECT Surname, Firstname, Team_Name, PostCode, Winner, Date_Of_Game, Place_Of_Game
     FROM tblPlayerProfile 
    INNER JOIN tblTeamDetails 
        ON tblPlayerProfile.Team_ID_Number = tblTeamDetails.Team_ID_Number 
    INNER JOIN tblMatchStatistics 
        ON tblTeamDetails.Team_ID_Number = tblMatchStatistics.Team_ID_Number
    INNER JOIN tblGameResults 
        ON tblMatchStatistics.MatchID = tblGameResults.MatchID
    WHERE (((tblGameResults.MatchID)=[FormsReport]![MatchFormReportD8]![Combo10]));

Syntax error with query on access

2 Answers2