*SOLVED* sorting 2 fields, both asc & dec

I am opening a table, no problem.. i need it to sort decending order though.
I need it to sort by Field YEAR (an integer) and field CASH (currency)

this is my sql statement so far.


sSQL = "Select * from INCSUMRY where year like " & intYear & " order by YEAR,MONEY"

any suggestions?


also, the data is renewed all the time, & is used by a cpl different programs, so i don't want it to resort the database permenantly.

geez.. ok. i solved it lol.


ORDER BY YEAR DESC, MONEY ASC