in my db..i saved the date as dd/mm/yyyy which the column to be searched.i saw it elsewhere that since the dtpicker is just a string so it can be chosen as any type as it is not following the system clock.

ok,before goin any further, is my code correct?
my intention for its job to be done is as follows:
check the db based on the dtpicker's date(2 different dates or same) then check the corresponding values in the AmountP...

I tried what you suggested there, and yes no error appears, but is it possible for it to retun "0" if the sum equals to 0?is there any way?

Initially in the DB the column Date datatype was text, but now i changed it to Date/Time but still error persist. Any ideas?...

Hi,

I am getting the error "invalid use of null" when summing value from a range which has no value and "data type mismatch in criteria expression" when there are values to be summed up. Is there an error in my code? could someone please point out the error and why am I gettin these errors.
...