>>i have changed the code as per your advice but it still does not work. I still think the problem is with the sql query:
>>
>>qry = "select * from kdata where k_date >= '" & datethen & " and"
>>qry = qry & " k_date <= '" & datenow & "'"
>>
>>since when i change the query to:
>>
>>qry = "select * from kdata"
>>

If the above "select * from kdata" is returning records and the qry variable is not, then, the query variable string has an error in it. Why don't you try printing the qry variable to the screen to make sure the correct values are plugged in.