Problema de estadísticas de tabla de inventario asp
sql = "SELECT sname AS [nombre del dispositivo]"
sql = sql & ",SUM(IIF(zt='nuevo producto',1,0)) AS [nuevo producto]"
sql = sql & ",SUM(IIF(zt='ejecutando',1,0)) AS [ejecutando]"
sql = sql &",SUM(IIF(zt=' a reparar', 1,0)) AS [a reparar]"
sql = sql & ",SUM(IIF(zt='desechado', 1,0)) AS [desechado]"
sql = sql & ",SUM(IIF(zt='D'.1,0)) AS [desconocido]"
sql = sql & " FROM [aa] GRUPO POR [nombre]"
Modificado...