Try to copy the SQL (output by Debug.Print) into Access SQL textbox then switch to Query Design to see what happens. Any misspelling name can be found easier.