Syntax Error (missing operator) in query expresssion in MS Access

Question

Access gives me a runtime error 3075 Syntax Error (missing operator). The SQL works in MS SQL Server 2012 but it doesn't work in Acces. Can someone help me?

Code:

CurrentDb.OpenRecordset("SELECT Gebruiker.[emailadres] FROM Voorwerp INNER
JOIN Bod ON Voorwerp.[Voorwerpnummer] = Bod.[Voorwerpnummer] INNER JOIN
[Gebruiker] ON Gebruiker.[GebruikersID] = Bod.[GebruikersID] WHERE Voorwerp.
[Voorwerpnummer] = 1")

Thank you in advance!

Carsten Flokstra

Gordon Linoff · Accepted Answer · 2016-05-24 12:49:52Z

5

MS Access requires more parentheses for joins. Try this:

SELECT Gebruiker.[emailadres]
FROM (Voorwerp INNER JOIN
      Bod
      ON Voorwerp.[Voorwerpnummer] = Bod.[Voorwerpnummer]
     ) INNER JOIN
     [Gebruiker]
     ON Gebruiker.[GebruikersID] = Bod.[GebruikersID]
WHERE Voorwerp.[Voorwerpnummer] = 1;

answered May 24, 2016 at 12:49

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error (missing operator) in query expresssion in MS Access

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related