What approach do I have to do for a chart.I have a table(called tblSell):
CurrentDate Amount
01.03.2003 100
01.03.2003 40
I need a chart something like:
0y: Amount (total in a month)
0x: Date (in characters: jan,feb...)
1.As you can see, the Date is numeric, I need character
2.Amount means that every sell that I make, in the tblSell table a new record appeared when I click the SAVE button.A record is the current date and the amount of cash.Now the question:
In the chart I need the Date in characters AND the TOTAL amount on that month.How can I add the daily amount so in the chart to view the monthly one?
CurrentDate Amount
01.03.2003 100
01.03.2003 40
I need a chart something like:
0y: Amount (total in a month)
0x: Date (in characters: jan,feb...)
1.As you can see, the Date is numeric, I need character
2.Amount means that every sell that I make, in the tblSell table a new record appeared when I click the SAVE button.A record is the current date and the amount of cash.Now the question:
In the chart I need the Date in characters AND the TOTAL amount on that month.How can I add the daily amount so in the chart to view the monthly one?