Results 1 to 6 of 6

Sort strings non alphabetically in query

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-14-2008
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    103

    Sort strings non alphabetically in query

    hi,

    I have a dataset with columns: date(daily), year, season, data1, data2,....etc.

    I have a simple query to sum the data cloumns by season for each year. However this puts the years in ascending order but the seasons in alphabetical order (Autumn, spring, summer, winter). Is there a way to force the output of the query to be a set order (Summer, Autumn, Winter, Spring)?

    Thanks,

    (ps. yes, I do want summer first as this is southern hemisphere seasons)
    Last edited by HammerTime; 09-28-2009 at 09:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1