Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Order By Month

Status
Not open for further replies.

Radman

Programmer
Jan 20, 2000
22
AU
Hi there,<br><br>I have a query.<br><br>i have a count that is grouped my month, now i want to order the query so that the results appear by month, unfortunatly since i only have the month is words in the query, it sorts the month alphabetically so instead of the results appearing like this:<br><br>Month:&nbsp;&nbsp;Number:<br>Mar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;45<br>Apr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;78<br>May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13<br><br>They appear like this<br>Apr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;78<br>Mar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;45<br>May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13<br><br>depending on whether it is ASC or DESC<br><br>Anyone got any hits<br><br>Thanks
 
try saving the date in standard numeric format and when it is output set the format so that it shows the month
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top