Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'data BETWEEN #07/01/2005# AND #07/11/2005#%' AND username Like '%%' AND visione Like '%%' AND statopratica Like '%%' AND agenzia Like '%%''.

/public/elencost.asp, line 147


questo lo script



codice:
strSQL = "SELECT * FROM immobili WHERE " 
strSQL = strSQL & " data BETWEEN #" & data1 & "# AND #" & data2 & "#"
strSQL = strSQL & "%' AND username Like '%" & Trim(Request.Querystring("username"))
strSQL = strSQL & "%' AND visione Like '%" & Trim(Request.Querystring("visione"))
strSQL = strSQL & "%' AND statopratica Like '%" & Trim(Request.Querystring("statopratica"))
strSQL = strSQL & "%' AND agenzia Like '%" & Trim(Request.Querystring("agenzia")) & "%'"