Mi sapete indicare qual'è l'erore nella stringa SQL

id campo tipo Contatore
ip campo tipo Testo (es.82.49.191.228)
robot campo tipo Numerico (vale 0 o 1)

codice:
 SQL = "SELECT id, ip, robot FROM log WHERE robot = 0 GROUP BY ip ORDER BY id desc"

Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation=3
rs.Open SQL, conn
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function.