I am trying to set up a sql statement to get a recordset from a database that sorts the recordset by three different fields, the first being rank the second being year and the third being month rank is ascending and year and month are descending - for some reason I cant figure out the correct syntax for the order by ....

sqlstr = "SELECT * FROM Press where press_active = true order by ???

any ideas...thanks

Your sql string is confusing. Do you mean?:

sqlstr = "SELECT * FROM Press where press_active = <something>
          ORDER BY rank asc, year desc, month desc"