Results 1 to 1 of 1

Thread: *SOLVED* sorting 2 fields, both asc & dec

  1. Apr 12th, 2004, 12:20 PM #1
    myrrdan
    myrrdan is offline

    Thread Starter
    Addicted Member myrrdan's Avatar
    Join Date
    Nov 2002
    Location
    Alberta Canada
    Posts
    202

    *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
    Last edited by myrrdan; Apr 12th, 2004 at 12:25 PM.
    Oooops.....theres another semi-colon in the wrong spot....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width