Grazie, ma mi devo essere perso qualche pezzo x strada..:

codice:
SQL = " SELECT "
SQL = SQL & " ID_CD, UM, "
SQL = SQL & "  SUM(TOT) AS strTOT, "
SQL = SQL & "  SUM(QUANT) AS strQUANT "
SQL = SQL & "  FROM TBL "
SQL = SQL & "  WHERE "
SQL = SQL & "  ID_CD = " & strID_CD & " "
SQL = SQL & "  GROUP "
SQL = SQL & "  BY ID_CD, UM "
SQL = SQL & "  UNION ALL "
SQL = SQL & "  SELECT NULL, UM, "
SQL = SQL & "  SUM(TOT), "
SQL = SQL & "  SUM(QUANT)"
SQL = SQL & "  FROM TBL "
SQL = SQL & "  WHERE "
SQL = SQL & "  ID_CD = " & strID_CD & " "

Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.21-community-nt]Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause