Search query help please

[Stelf]

Hiya,

Hope someone can help me, is it possible to make sql query language sort by one row and then in the same query sort by another row.

What I would like to do is make it sort by YEAR, and then sort by a weight row so they get placed in the right order for that year, whilst still maintaining the year order.

Thanks in advanced.

Ben

[irishprogrammin]

can't you just use an:

"ORDER BY column_1_name, column_2_name"

should work just fine...

[Stelf]

Thanks 🙂