Search Query Based On Date - Records From A Table In MsAccess And Displaying In A Listview

I used following code searching records from a table in MsAccess and displaying in a Listview and it is working fine with the search criteria based on Discription.

CODE:

I also tried the above code to search records on the base of CustId and it worked fine too.My table DailyTransaction in MsAccess is as under:DTDate, DTTime, CustId, Description, Quantity, Price, Amount, AccountNumber, Name

Now I want to Search records on the base of Date I tried the following but it did not work.

Dim cmdText As String = "SELECT * FROM DailyTransaction WHERE DTDate=' " & TextBox1.Text & " ' "

Also i want to make following sort of query to retrieve data between two dates and to display the sum of amount group by DTDate. I could sketch following query and deifinitely it is so wrong with Syntex.Select * From DailyTransaction where DTDate Between textbox1.text AND textbox2.text Group By DTDate AND SUM(Amount)