SELECT date, SUM(amount) as total_amount
FROM tblSales
GROUP BY date
WHERE  date >= '02/01/2007'  
AND  date <= '02/30/2007'
ORDER BY date