>Does anybody have a chart sample using only 2 fields : month and sum ?
>
>I got the code below here in the forum, now I want to send it to a chart
>
>SELECT cMonth(Date) AS Month, SUM(Price) AS Sum ;
> FROM Financial ;
> GROUP BY Month(Date) ;
> INTO CURSOR TempCursor
I don't know about the chart - Excel might be an option.
But does the group by month(date) really work? As far as I have seen, you either have to specify a field, or the result column by number, as in the example I gave you in the other thread.
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)