Hello<BR><BR>I've got a query set up but it's creating an error in the FROM section:<BR>Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. <BR><BR>/brumunichess/db/fixtures.asp, line 16 <BR><BR>I've managed to narrow it down to the following line....<BR><BR>strQ = "SELECT Players.Name, Players.Grade, Players.[Matches Played], Players.[Matches Won], Players.[Points Scored] FROM Players "<BR>strQ = strQ & "WHERE (((Players.Team)=Division 3)) " <-- Error here<BR>strQ = strQ & "ORDER BY Players.Team, Players.Name; "<BR><BR>It works fine when the WHERE query is taken out but when that's in it fails! I think it's because the Division 3 part should be in "" but when I add them in the query obviously fails because it thinks it's got to the end of the line <BR><BR>Any ideas or am i just being dumb?