🚀 go-pugleaf

Hi!
Iam using c++ builder 5 enterprise edition. MS access 2000 is my database.
I have a listbox in my application which contains date/Time values.
For example: an item in listbox is 12.11.2004 11:12:24 - 12.11.2004 13:12:24
When ever an item is selected on the listbox, I select the values that are
between the time period and display on TDBChart.
I used TADOQuery. TDBChart datasource is TADOQuery.
So far it is fine.
If I enable the multiselect option on the list box, the user can select
multiple items on the listbox not necessarily in sequential order.
For example: items 1,3,6 are selected.
Now i have to display the values that are between the time specified by
item1, time specified by tem 3 and time specified by item 6.
How can i display the combination of these recordset on the TDBChart.
I can use "where time between and time between....." in the SQL query.
If 50 items are select, then i have to 50 time between in my sql.
Is there any other method by which I can add the dataset generated by each
item selection of the listbox and display on the DBChart.
Is this the good way?
Regards,
siraj