I can get it listed on the grid in either ASC or DESC order no prob, but how do I override the order?

I have an example like:

strSQL = "SELECT * FROM myTable ORDER BY inv_status ASC"

rs.cursorlocation = adUseClient
set mshflexgrid1.datasource = rs

This would display in the order:
not paid, open, paid, unlikely

What if I want the order different and not ASC or DESC? Such as not paid, open, unlikely, and paid.

Thanks for the quick reply.

Eric