VB6 Chart data

Hello experts,

I am using a CMD button with this code:

Adodc2.RecordSource = "select DTIME, NETSALES from data where opendate = '" & OPENDATE.Caption & "'"
Adodc2.Refresh

This produces a result similar to:

3:00:00PM $100.00
3:00:30PM $115.00
3:01:00PM $125.00
and so on, in DataGrid2. Now my question is how can I chart this DataGrid2 data in an MSChart?

DTIME should be X axis and NETSALES be the Y axis

The data table is located in an Access DB.

Looking forward to your replies :)
triphenAsked:
Who is Participating?
 
coolcurrent4uCommented:
first of all, all date queries should be done this way

Adodc2.RecordSource = "select DTIME, NETSALES from data where opendate = #" & trim$(OPENDATE.Caption) & "#"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.