i have made a software for medicine distributor
i wanna show the reports for orders placed to a pharmaceutical company within specific period of time
i wrote
rs.Open "Select * from placedorder where PLACE_DATE between " & Txtdate.Text & " and " & txtdateto.Text & " ", con, 3, 3
but im getting all records from the db being displayed during run time ,
but
i want records between specific date that user enters during run time
so please any one help me out with the query