SELECT * FROM myTable ORDER BY Year(myDateColumn), Month(myDateColumn)
SELECT tblBills.*, MonthName(month(tblBills_1.Due_Date)) AS month1 FROM tblBills inner join tblBills AS tblBills_1 on tblBills.ID=tblBills_1.ID order by tblBills_1.Due_Date
ORDER BY
... ORDER BY DateField
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)