Ho fatto la select sottostante e mi riporta l'errore che non so da cosa dipende.

Il campo ID_barca e di tipo numerico (intero lungo).
L'errore è avvenuto quando ho messo WHERE ID_barca = 3



SELECT DISTINCT Start_Date, End_Date FROM tEvents WHERE (Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) WHERE ID_barca = 3 ORDER BY Start_Date

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

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Start_Date >=#01/10/2005# AND Start_Date <= #31/10/2005#) OR (End_Date >=#01/10/2005# AND End_Date <= #31/10/2005#) OR (Start_Date < #01/10/2005# AND End_Date > #31/10/2005# ) WHERE ID_barca = 3'.

/team_calendario.asp, line 185