i want to get the total amount of price from one of the column in a table.
i've use datepicker for choose the date that i want to use for calculate the price

this is the example of my coding.

strSql = "SELECT Sum(DispAmt) As TotalDisposal from queAnaPro Where DispDate Between " & DateFrom.Value & " AND " & DateTo.Value & " "
rec1.Open strSql, Con, adOpenStatic...