Question and Answer Database FAQ12B.txt 'Syntax error in query. Incomplete query clause' Category :Database (MSACCESS) Platform :Win95/NT Product : Question: "Syntax error in query. Incomplete query clause" error: I get this error when I run a query against a table with a space in the table name. I have double quotes around the name but it still does not work. What am I doing wrong? Answer: You need to change the double quotes " " to brackets [ ] Example: SELECT * FROM "MY TABLE NAME" needs to change to SELECT * FROM [MY TABLE NAME] 7/15/98 3:23:06 PM
Last Modified: 01-SEP-99