on page 259 in Beginning Access VBA 2000 I can't get this line to execute:

CurrentDb.QueryDefs("qryExample").SQL = strSQL

I get this error message:
Runtime error 3131, Syntax error in FROM clause

the code is producing the SQL string but not passing it to the Query

does anyone have any suggestions? thanks!

I found the error, missed the last space at:

strFROM = "tblSales s "