>Thanks Hilmar.
>I assume month refers to the function month()?
Ulises,
Estaba suponiendo - por fines de simplicidad - que ya tenías una columna con el nombre "month". De otra manera, la podrías seleccionar:
select left(dtos(FechaVenta),6) as Mes, sum(Total as xSum;
from Ventas;
group by Mes;
order by Mes;
into cursor Resumen
Saludos, Hilmar.
>I'm trying this with no results:
>
>select datesale,sum(total) as xsum from sales group by month(datesale) order by datesale into cursor resumen
>
>I can't get the results grouped and summarized by month
>
>Ulises
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)