SQL Multiple Sort Help

[sgore]

I need a quick way to sort by two seperate fields in a database.

field1 = month
field2 = day

I would like to sort by month first and print out the month (only once) and then sort the days in that month. One I get to another month I need to repeat the process

Here is the current SQL I have:
mySQL ="select * from practice order by month Ascending"

is there anyway to add the second sort (sort by day ascending) into the SQL statement above?

 

[sgore]

Never mind... I am an idiot....

select * from practice order by month, day ascending

 

[ToddWW]

Not really.

Tip: When working with certain types of recordsets, you can sort or filter after you have populated the recordset as well.

Once your recordset is populated, you can issue sql statements on the recordset using the sort and filter methods. Like this.

Rs.Sort = "month, day DESCENDING"

OR

Rs.Filter = "month = 'March' AND day = '1'"

Just some food for thought ..

TW