Little chance of helping you without being able to see your query sql statement, except to say that if you have spaces in names (e.g. Customer Orders) then you must surround such names with [brackets]. Or you're missing data type delimiters. You could also switch to sql view in Access and switch to datasheet view. It will often highlight the offending portion of the sql in sql view.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.