OK, this is an slow, ugly solution, but it will solve your problem.
If I am extrapolating from the results set show correctly, you are looking for a total to be displayed by day of all sales between the beginning of the date range and the current date of the date range.
SELECT...