need help plotting chart in VB

[ashraf83]

hi guys, i need help plotting chart in Vb, im using SQL to plot the chart but when i use it the first data wont be included in my chart , let say if it was supposed to be data range from 3/1/2006 to 3/31/2006 , data from 3/1/2006 wont be displayed but started at 3/2/2006! the code im using is :

rs.Open "Select S1,S2,S3,S4,Q from test2 where [Nama Pa] ='" & x & "' and Tarikh between #" & mula & "# and #" & tamat & "# ORDER BY Tarikh ASC", cn, adOpenDynamic, adLockOptimistic

and one more thing, can or cannot MSchart display date such as 3/1/2006 as X-axis? because in my case it would'nt show anything or i only has to use something like text or number but not date??

Im using Vb 6 and Ms Access, plot the chart using MsChart.

please help me, any help would be greatly appreciated. :)