<div>
first of all, all date queries should be done this way<br />
<br />
Adodc2.RecordSource = &quot;select DTIME, NETSALES from data where opendate = #&quot; &amp;&nbsp;trim$(OPENDATE.Caption) &amp;&nbsp;&quot;#&quot;
</div>


first of all, all date queries should be done this way

Adodc2.RecordSource = "select DTIME, NETSALES from data where opendate = #" & trim$(OPENDATE.Caption) & "#"

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I am using a CMD button with this code:<br />
<br />
Adodc2.RecordSource = &quot;select DTIME, NETSALES from <b><u>data </u></b>where opendate = '&quot; &amp;&nbsp;OPENDATE.Caption &amp;&nbsp;&quot;'&quot;<br />
Adodc2.Refresh<br />
<br />
This produces a result similar to:<br />
<br />
3:00:00PM $100.00<br />
3:00:30PM $115.00<br />
3:01:00PM $125.00<br />
and so on, in DataGrid2. Now my question is how can I chart this DataGrid2 data in an MSChart?<br />
<br />
DTIME should be X axis and NETSALES be the Y axis<br />
<br />
The <b><u>data </u></b>table is located in an Access DB.<br />
<br />
Looking forward to your replies :)<br />

</div>
</div>


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 :)


VB6 Chart data

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.