I have a sales database, with each sale is a date for the sale.

i want to group on the date, so that i have a nice graph with each date and the number of sales.

but if there are no sales on that day, it doesnt group on the day at all, and the day wont be in the graph.

what i want is a DAY BY DAY graph so you can see the full ups and downs of the sale flow.

suggestions?