Código SQL [-]SELECT TOP (100) PERCENT coditem, SUM(Cantidad) AS TOTALVTA FROM dbo.VW_ADM_ITEMSFACTURA WHERE (FechaEF BETWEEN DATEADD(year, - 1, GETDATE()) AND GETDATE()) GROUP BY coditem, TipoFac HAVING (TipoFac = 'A') ORDER BY coditem
SELECT TOP (100) PERCENT coditem, SUM(Cantidad) AS TOTALVTA FROM dbo.VW_ADM_ITEMSFACTURA WHERE (FechaEF BETWEEN DATEADD(year, - 1, GETDATE()) AND GETDATE()) GROUP BY coditem, TipoFac HAVING (TipoFac = 'A') ORDER BY coditem