error message in access: syntax error in query

Question

I'm trying to do this query in access but I am getting this error "syntax error in query. incomplete query clause". Should I be rewriting it as a join statement instead?

select

'MAIN DATABASE'.CoupaREQ,  

'MAIN DATABASE'.OldServiceTag,  

'REQ Lookup'.'Old Tag Serial', 'REQ Lookup'.'Coupa Req',  

'REQ lookup'.'Req From Tracker' 

from

'MAIN DATABASE', 'REQ Lookup' 

where

'MAIN DATABASE'.ID = 'REQ Lookup'.ID ;

Answer 1

It may be your use of single quotes around the table names. Try using square brackets instead. For example:

[MAIN DATABASE] and [REQ Lookup]

Hope that helps...

Answer 2

Hi. Glad to hear you got it sorted out. It's highly recommended to avoid using spaces in table names to prevent unexpected problems like this. Good luck with your project.

Answer 3

Yes, very true... what I did was I went back in query, used designer and made a simple query to see how access laid the querys out, then moved on till i got what I wanted, I was able to see how access wanted it formatted. It was definitely a lot of the issue of needing brackets.

Answer 4

theDBGuy is right.

One way to learn the SQL syntax is to first design a query in the Designer, then switch to SQL view. You will see the use of square brackets.