it's an attendance so the dbf is passing data to the vb and i query in the vb about the dbf and pass the value to sql server .
so i just want to pass the values that are inputed in the dbf where curddate or the date and time now - 20000 secs :D it's dynamic and its running on a service thanks :D
i'll post the query tom
VB.DBF query = Select empno,logtime where datetime = current date and time - 20000 secs ? i don't know how to query it :D