HI All,<BR><BR>I am facing a problem actually i had developed timesheet module and now i want to use query for administrator use depending on the start date and end date it should show the relevant information from that table and for that i am using one asp page from where i am selecting dates and in other page collecting values but i don&#039t know how to proceed i am placing the code below so could somebody look at it and give me some idea.<BR><BR>&#060;%<BR>str = CDate(request.form("ma")& "/" &request.form("mb") & "/" & request.form("mc"))<BR>strTemps = CDate(request.form("b1")& "/" &request.form("b2") & "/" & request.form("b3"))<BR>response.write str<BR>response.write strTemps<BR>Set Con=Server.CreateObject("ADODB.Connection")<BR>Con .Open("Driver={SQL Server}; Server=webservernew;uid=sa;pwd=;DATABASE=timesheet ")<BR>Set RS = Server.CreateObject("ADODB.Recordset")<BR>RS.Curso rType = adOpenStatic<BR>RS.Open "SELECT EmpTrans.User_Name, EmpTrans.sDate, EmpTrans.Activity, EmpTrans.Duration, EmpTrans.Process_id, EmpTrans.Reviewed FROM EmpTrans" WHERE ((("sdate")&#062;="str" Or ("sdate")&#060;="strtemps"))"con<BR><BR><BR>ORD ER BY EmpTrans.User_Name;<BR>if RS.EOF then<BR> Response.Write "No records"<BR>else<BR> Response.Write "Records Retrieved"<BR>end if<BR>%&#062;