This is my MS SQL query select LicenseNo, month(timeIN) as month, count(visitID) as bilPatient from visit where HQLicenseNO='MYHQD00007' and year(timeIn)=2007 group by LicenseNo, month(timeIN) order by month this gave result as below LicenseNo month bilPatient MYCLD00008 1 1 MYCLD00008 8 9 MYCLD0000...

Thank you very much Narcís...
it works!...


this is example from the sql query

whour (Y value) : 7 8 9 10
BillPatient (* X value): 1 6 14 5

why X value sometimes start with 1 or 2. It should start with 0

Hi Narcís,

Thanks for immediet reply.
I'll try it soon.

erm...is there a codes where by i can change the whour into 12 hour format rather than 24 hour format?

Hi all, I'm new with TeeChart. I have create a simple TeeChart where the data read from our database. For example: <!--#include file = "../Idle.asp"--> <!--#include File = "../../DBConnection/epmiDB.asp"--> <!--METADATA NAME="TeeChart Pro v6 ActiveX Control" TYPE="TypeLib" UUID="{54294AC6-FA71-4C7F-...

Thanks Edu...

hi... i'm new in TeeChart. I've go through TeeChart about 1 month. I start to create a chart in VB. i want to ask about the series properties. 1. how i can set the series color. I used the default TeeChart color there is red, green and yellow. sometime i also used vbCyan, vbBlue... I write as Chart....