Microsoft query question

[dracer]

Hi there. I was wondering if someone can help with this Microsoft Query issue. I have a staff that's set up and can connect to the server and to the reports and when we try to run a report on his computer he gets the below message. My computer has no problem running the report. Does anyone have any suggestions on this?

"AN object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as '"' or are not allowed. Change the alias to a valid name
Unclosed quotation mark after the character string ".
Incorrect syntax near ".
Statements could not be prepared"

 

[Fazza]

please check the SQL syntax

and check the field names - for characters like ' and ` and "
if found can you remove & test without them. if that is OK try re-introducing them with [the field name enclosed in brackets like this]

and check that the field names in the SQL exactly match the actual field names in the table