Solved Syntax error

[Gasman]

Thank you. My concatenation was indeed off. It works.

If you are not that great at doing it all in one statement, break it down to components so you can debug.print them.
I often have strSelect, strWhere, strOrder if the contents can vary, then just concatenate those with a space.
HTH

 

[Isaac]

Great trick while debugging print the sql statement then pop it into a new query window and try to run it